phpMyAdmin won't let me DROP DATABASE but console will.

[Slips]

Hello,

 

Not really a major issue, just something that's coming in the way here and there.

 

Basically i created a user with ALL privileges only on user_% database and absolutely no GLOBAL privileges.

 

The problem is that i'm able to execute the CREATE DATABASE command under that user but i'm not able to do a DROP DATABASE statement in phpMyAdmin (Gives me a javascript dialog box that says "DROP STATEMENTS are disabled!", and i'm not able to delete it from the phpMyAdmin GUI under the Databases tab (Checkbox to select is missing).It works without any issues if i do it in the Mysql console. I'm continuing to work on the Mysql, but now and then when i need to get into phpMyAdmin its annoying , not being able to do this.

 

Mysql Version : 5.1.41-3ubuntu12.7

phpMyAdmin Version : 3.3.2deb1

 

Thanks in advance!

[jdavidbakr]

Sounds like the phpMyAdmin config value of 'AllowUserDropDatabase' is probably set to false on your server:

 

http://www.page-zone.com/forums/general-questions-comments/124-phpmyadmin.html