Ybierling

How to delete a database in phpMyAdmin

• Or visually by following below steps
• There, once in the database, go to the menu Operations
• Similar articles
• Comments (9)

Deleting a database in phpMyAdmin is pretty easy and straightforward, but also very dangerous. Make sure that a 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 :

Attribution-NonCommercial-ShareAlike

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

Attribution-NonCommercial-ShareAlike

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

Attribution-NonCommercial-ShareAlike

A popup will ask confirmation to destroy the complete database.

Attribution-NonCommercial-ShareAlike

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.

Attribution-NonCommercial-ShareAlike