phpmyadmin enable drop database statement

Question

I was alerted by my hosting provider that I exceed my 1000 table limit. I have a lot of databases and would like to delete more at once. Unfortunaltley they don't have a multiselect feature so I decided to use a query in phpmyadmin.

When I try something like DROP database some_name I get DROP DATABASE statements are disables

Does anyone know if it's possible to enable them or a different way to delete multiple databases?

Answer 1

1. Go to -> your_drive/xampp/PhpMyAdmin/libraries/ (Windows with XAMPP) or /usr/share/phpmyadmin/libraries/ (Linux with PHP/Apache/MySQL/PhpMyAdmin)

2. Open a file name “config.default.php“

3. Find $cfg['AllowUserDropDatabase']

4. You will find the value is “False. Make it to ”True”.

5. Linux restart apache2 in termina /etc/init.d/apache2 restart (Linux) or XAMPP Control Panel restart Mysql

Answer 2

It looks like there is a phpMyAdmin setting that you need to edit in config.inc.php.

boolean $cfg['AllowUserDropDatabase'] (line 503)

show a 'Drop database' link to normal users

Answer 3

if you are using version 4+ then you can simply drop a database just following these steps:

1. go to mysql admin
2. click database option (right side of your databases)
3. here you will get all the databases you have and now click the checkbox at the left side of the databases you want to delete
4. just the bottom of these databases you can see the option "Drop" so click the drop to delete the database permanently

Answer 4

Yes, you can do it with the following steps:
1. Go to wamp/apps/phpmyadmin3.5.1/libraries
2. Open the file called "config.default.php"
3. Go to line 653 and change $cfg['AllowUserDropDatabase'] = false; to true
4.Restart the server to see the changes

Restart the wamp ...Close wamp server and open again. :)

Enjoy!

Answer 5

Yes, you can do it with the following steps:

1. Go to wamp/apps/phpmyadmin3.5.1/libraries

2. Open the file called "config.default.php"

3. Go to line 653 and change $cfg['AllowUserDropDatabase'] = false; to true

4. Restart the server to see the changes

For Windows XP users: if the effect is not reflected, exit WAMP through the quick launch icon and try restarting it.

Answer 6

Drop the database and create a new one. To do so, go to phpmyadmin and select the database over the left panel. Then Go to 'Operations' tab on the head. Find the option to Remove Database at middle right. Click on DROP DATABASE and way to go...