[phpmyadmin] Delete a database in phpMyAdmin

By mistake, I have created a duplicate database in the phpMyAdmin page of cPanel. I want to delete this database, but I am not able to find any delete button in the UI.

How to delete a database in phpMyAdmin?

You can follow uploaded images

Then select which database you want to delete

Taking a queue from michael's answer above, I was unable to find the DROP Database command on my phpMyAdmin console in the localhost.

Apparantly I was missing a setting. Go to config.inc.php file of the phpMyAdmin folder, and add this:

$cfg['AllowUserDropDatabase'] = true;

Save and restart the local server and the command appears inside the console.

Go to operations tab for the selected database and click "Drop the database (DROP)" to delete it.

How to delete a database in phpMyAdmin?

From the Operations tab of the database, look for (and click) the text Drop the database (DROP).

Open the Terminal and run

 mysql -u root -p

Password is null or just enter your mysql password

Ater Just Run This Query

 DROP DATABASE DBname;

If you are using phpmyadmin then just run

 DROP DATABASE DBname;

If you want to delete your database from phpmyAdmin or mySQl. Simply go to SQL command and write command "drop DATABASE databasename;"

Example: drop DATABASE rainbowonlineshopping;

Then click on "Go" Button. Your Database will be deleted and you get information like this

The delete / drop option in operations is not present in my version.

Go to CPanel -> MySQLDatabase (icon next to PhPMyAdmin) -> check the DB to be delete -> delete.

1. Go to phpmyadmin home page.
2. Click on 'Databases'.
3. Select the database you want to delete. (put check mark)
4. Click Drop.

Follow the following steps to delete database in PhpMyAdmin.

1. Select your database.
2. Choose the "Operations" tab.
3. On this page under remove database, you will find a "Drop the database (DROP)"

Hope this helps.

1. Connect to your localhost.
2. Open your favorite browser.
3. Make sure your localhost is working.
4. Type in url= localhost.
5. Scroll down click on phpadmin once phpadmin is open.
6. Click on database.
7. Mark check the database you want remove.
8. Click on drop.

If this don't work

1. Click on database go to operation
2. Click drop database

You can delete the database in Cpanel.

In Cpanel go to databases and there you will see all created databases and you can delete this database.

http://docs.cpanel.net/twiki/bin/view/AllDocumentation/CpanelDocs/MySQLDatabases#Delete a Database

or other wise on live server if user have privileges you can run command in sql tab of phpmyadmin.

drop database databasename;

database_name -> Operations -> Remove database -> click on drop the database (DROP)

There are two ways for delete Database

1. Run this SQL query -> DROP DATABASE database_name
2. Click database_name -> Operations ->Remove Database

select database on the left side. Then on the right-central top you can find Operations. In that go for remove database (DROP). That's all.

On phpMyAdmin 4.1.9:

database_name > Operations > Remove database