Slips Posted November 24, 2010 Share Posted November 24, 2010 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! Quote Link to comment https://forums.phpfreaks.com/topic/219663-phpmyadmin-wont-let-me-drop-database-but-console-will/ Share on other sites More sharing options...
jdavidbakr Posted November 24, 2010 Share Posted November 24, 2010 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 Quote Link to comment https://forums.phpfreaks.com/topic/219663-phpmyadmin-wont-let-me-drop-database-but-console-will/#findComment-1138978 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.