How to delete a database in phpMyAdmin



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 :

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

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

A popup will ask confirmation to destroy the complete database.


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.



International Business Consulting
About the author - International Business Consulting
Yoann is an International Business Consultant, facilitator and coordinator. He worked more than 10 years in global business, supply chain, financial, SAP ERP projects, Web and SEO optimization for various industries, such as logistics, cosmetics, consumer goods, beauty care, or fashion, in more than 30 countries around the globe.
 


Comments (9)

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

Leave a comment