Web-en

How to delete a database in phpMyAdmin

Deleting a database in phpMyAdmin is pretty easy and straightforward, but also very dangerous. Make surea backup is available before doing so, and that the right database has been selected !
Using SQL, this syntax will do the trick, by replacing the database name for the one on the local MySQL server :

DROP DATABASE `database`

Or visually by following below steps

First, log on to the localhost phpMyAdmin, or the remote phpMyAdmin if working on a distant server :

How to delete a database in phpMyAdmin : Selecting the database to delete in main screen
Selecting the database to delete in main screen

There, once in the database, go to the menu Operations

How to delete a database in phpMyAdmin : Finding the operations menu once the database to delete has been selected
Finding the operations menu once the database to delete has been selected

In the operations menu, a red link drop the database will be displayed, click on it

How to delete a database in phpMyAdmin : Drop the database link
Drop the database link

A popup will ask confirmation to destroy the complete database.

How to delete a database in phpMyAdmin : Confirm database deletion
Confirm database deletion

As the operation is non reversible, double check that the right database has been selected

After the database deletion is complete, interface redirects to main phpMyAdmin page, with a popup MySQL returned an empty result set, as no row have been selected, and the database should not be available anymore.

How to delete a database in phpMyAdmin : Database successfully deleted
Database successfully deleted