Take the 2-minute tour ×
Ask Ubuntu is a question and answer site for Ubuntu users and developers. It's 100% free, no registration required.

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.
share|improve this question

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.