I just upgraded from 10.04 to 12.04.
Now, when I try to drop a database in phpmyadmin it gives me an error saying that DROP DATABASE
statements are disabled.
After reading up on this I added this line
$cfg['AllowUserDropDatabase'] = true;
to the bottom of /etc/phpmyadmin/config.inc.php
, but I still get the same message.
I logged out of phpmyadmin, rebooted and logged back in, but still no change.
Any ideas?
UPDATE:
OK, I have discovered a few more details:
- I can drop a database from PHPMyadmin by clicking on the DROP link. I can not, however, drop by typing the SQL directly.
- I can drop a database from the command prompt, no problems
- There is one particular database that seems to be screwed up. If I try to DROP from the command prompt, it says it has lost connection to the server. If I try from within PHPMyadmin, it errors out and logs me out instantly.