On 12/12/07, Galen Charlton <galen.charlton@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@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' | +