DROP DATABASE in phpMyAdmin

Question

DROP DATABASE in phpMyAdmin

Asked 10 years ago

Viewed 4,154 times

0

How do I enable DROP DATABASE in phpmyadmin?

Every time I try to drop a bank gives error saying that the command is not enabled.

I’m using phpMyAdmin on my local machine’s WAMP.

Is it a local bank or an external server? It may be some restriction of the bank user’s permission. Go to [Edit] to enter more relevant details.

– gmsantos

2014/10/24 at 18:19

2 answers

Browser other questions tagged php mysql phpmyadmin

You are not signed in. Login or sign up in order to post.

by gmsantos • **17,221** points · Answer 1 · 2014-10-24T18:31:49+00:00

In phpMyAdmin if I do not have memory of the command DROP DATABASE is disabled for security reasons.

To activate it you need to change the phpMyAdmin configuration.

Look for the line AllowUserDropDatabase in the archive config.inc.php in the phpMyAdmin folder and change its value to true.

Once done, restart Wamp services and your Mysql will be ok.

Reference:

http://docs.phpmyadmin.net/en/latest/config.html#cfg_AllowUserDropDatabase

by Meireles • 69 points · Answer 2 · 2019-10-01T19:44:21+00:00

Very easy: If you are in phpMyAdmin go to the control panel and also open the MySQL® Databases (where the databases and their users are created). Below, under Current Databases, you can view the databases created, JUST SELECT THE DATABASE YOU WANT TO DELETE and click REMOVE.