How to delete a database in phpMyAdmin

Quick links

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

Similar articles

Comments (9)

Martin Christensen, 2018-08-19
Bu bilgiyi okumak için harika zaman geçirdim, iyi çalışmaya devam et
Jessica Lee, 2018-08-19
這對我來說效果很好,無需進一步了解
Enjoydstone, 2018-08-19
Ճիշտ այնպես, ինչ ես փնտրում, կատարյալ
Forlifecent, 2018-08-19
Դա լավ է աշխատել ինձ համար, այլեւս կարիք չկա փնտրել
RelaxMaxi, 2018-08-19
Nagyszerű információ, köszönjük a megosztást
vbmarcj, 2018-08-19
نعم ، هذا ما احتاجه
svirkomt, 2018-08-19
それは私のためにうまくいったので、これ以上見る必要はありません
equingifinaj, 2018-08-19
Sizga qanday qilib rahmat aytishni bilmayman, lekin bu sof daho, rahmat
skryfstylK, 2018-08-19
Ei tea, kuidas teid tänada, aga see on puhas geenius, aitäh

Leave a comment