DROP DATABASE in phpMyAdmin

Asked

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.

2 answers

3

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

0

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.

Browser other questions tagged

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