Delete a database in phpMyAdmin

Question

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

User · Answer

If you want to delete your database from phpmyAdmin or mySQl. Simply go to SQL command and write command "drop DATABASE databasename;"

Example: drop DATABASE rainbowonlineshopping;

Then click on "Go" Button. Your Database will be deleted and you get information like this

User · Answer

database name -  Operations -  Remove database -  click on drop the database  DROP

User · Answer

There are two ways for delete Database   Run this SQL query -  DROP DATABASE database name Click database name -  Operations - Remove Database

User · Answer

Go to operations tab for the selected database and click  Drop the database  DROP   to delete it

User · Answer

select database on the left side  Then on the right-central top you can find Operations  In that go for remove database  DROP   That s all

User · Answer

Follow the following steps to delete database in PhpMyAdmin    Select your database  Choose the  Operations  tab  On this page under remove database  you will find a  Drop the database  DROP     Hope this helps

User · Answer

You can follow uploaded images    Then select which database you want to delete

User · Answer

On phpMyAdmin 4 1 9   database name  gt  Operations  gt  Remove database

User · Answer

Connect to your localhost  Open your favorite browser  Make sure your localhost is working  Type in url  localhost  Scroll down click on phpadmin once phpadmin is open  Click on database  Mark check the database you want remove  Click on drop   If this don t work  Click on database go to operation Click drop database

User · Answer

You  can delete the database in Cpanel   In Cpanel go to databases and there you will see all created databases and you can delete this database   http   docs cpanel net twiki bin view AllDocumentation CpanelDocs MySQLDatabases Delete a Database  or other wise on live server  if user have privileges you can run command in sql tab of phpmyadmin             drop database databasename

User · Answer

Taking a queue from michael s answer above  I was unable to find the DROP Database command on my phpMyAdmin console in the localhost   Apparantly I was missing a setting  Go to config inc php file of the phpMyAdmin folder  and add this    cfg  AllowUserDropDatabase     true   Save and restart the local server and the command appears inside the console

User · Answer

The delete   drop option in operations is not present in my version    Go to CPanel -   MySQLDatabase  icon next to PhPMyAdmin  -  check the DB to be delete -  delete

User · Answer

How to delete a database in phpMyAdmin    From the Operations tab of the database  look for  and click  the text Drop the database  DROP

User · Answer

Go to phpmyadmin home page  Click on  Databases   Select the database you want to delete   put check mark  Click Drop

User · Answer

Open the Terminal and run   mysql -u root -p   Password is null or just enter your mysql password  Ater Just Run This Query    DROP DATABASE DBname      If you are using phpmyadmin then just run    DROP DATABASE DBname

User · Answer

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

[phpmyadmin] Delete a database in phpMyAdmin

Examples related to phpmyadmin