By mistake, I have created a duplicate database in the phpMyAdmin page of cPanel. I want to delete this database, but I am not able to find any delete button in the UI.
How to delete a database in phpMyAdmin?
Deleting a MySQL or MariaDB databaseUse the command 'SHOW DATABASES;' in the mysql-console like in the example above. Now copy the name of the database you want to delete. To do delete a database you need the command 'DROP DATABASE'. The syntax is similar to creating a database.
In Object Explorer, connect to an instance of the SQL Server Database Engine, and then expand that instance. Expand Databases, right-click the database to delete, and then click Delete. Confirm the correct database is selected, and then click OK.
The only phpMyAdmin related database (as you probably already guessed) is phpmyadmin , you can delete it, but letting it be there would improve performance, and add more functionality to the phpMyAdmin .
On phpMyAdmin 4.1.9:
database_name > Operations > Remove database
After successful login to cPanel, near to the phpMyAdmin
icon there is another icon MySQL Databases
; click on that.
That brings you to the database listing page.
In the action column you can find the delete database
option click on that to delete your database!
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With