Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Delete a database in phpMyAdmin

Tags:

phpmyadmin

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?

like image 422
coder Avatar asked Feb 13 '14 10:02

coder


People also ask

How do I delete an existing MySQL database?

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.

How do you delete 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.

Can I delete the default databases in phpMyAdmin?

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 .


2 Answers

On phpMyAdmin 4.1.9:

database_name > Operations > Remove database

enter image description here

like image 111
Mars Robertson Avatar answered Oct 02 '22 20:10

Mars Robertson


After successful login to cPanel, near to the phpMyAdmin icon there is another icon MySQL Databases; click on that.

enter image description here

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!

like image 21
psanjib Avatar answered Oct 02 '22 19:10

psanjib