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.
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.