PhpMyAdmin No Drop Database Option + SQL Drop Commands Disabled

2k views Asked by At

I have tried altering config.default.php, config.inc.php, common.inc.php, to include $cfg['AllowUserDropDatabase'] = true; none of this results in the Drop Database option tab. When I try to use SQL statements directly I get a message that they are disabled. Version 3.5.8.2 phpMyAdmin running on shared host - NOT wamp. What else is there to try?

1

There are 1 answers

1
Isaac Bennetch On

3.5.8.2 is somewhat outdated; you should try to update to the 4.x version if possible. However, what you're trying should work.

To be clear, config.inc.php is the proper file to modify (in the root phpMyAdmin folder). You can add a line like

die("config.inc.php is being read properly");

to the end of config.inc.php to make sure you're actually editing the proper file.

Although I don't have an installation that old to test one, I think the DROP DATABASE link is shown in the Operations tab; are you sure you're looking in the right place? Are you sure this user has the proper permissions within MySQL? You can check what permissions a user has through the Users tab (which I think is "Privileges" in 3.5.x).