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.
Have you read?
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.
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.
