[Koha-devel] Re: RFC - installer changes

[Bradley Peters]

On 12/12/07, Galen Charlton <galen.charlton at liblime.com> wrote:
> Odd, it should check for 'ALL PRIVILEGES' or for specific grants,
> including 'DROP'.  Could you send me the output of the following mysql
> query:
>
> SHOW GRANT FOR 'kohaadmin'@'localhost';

Apparently kohaadmin is only granted SELECT. I guess I did something
wrong when I created that database.

Here is the reponse copied from the mysql shell (I just deleted the
long "--" lines).

+
| Grants for kohaadmin at localhost
                                            |
+
| GRANT USAGE ON *.* TO 'kohaadmin'@'localhost' IDENTIFIED BY PASSWORD
'*CAAD8B29D8D65D2737D51F1A3F726F262C5EE65E' |
| GRANT ALL PRIVILEGES ON `mbom-test`.* TO 'kohaadmin'@'localhost'
                                            |
| GRANT SELECT ON `koha`.* TO 'kohaadmin'@'localhost'
                                            |
+