Removing a database in phpMyAdmin

Question

By mistake, I created a duplicate database on the phpMyAdmin cPanel page. I want to delete this database, but I cannot find the delete button in the user interface.

How to delete a database in phpMyAdmin?

Answer 1

After successfully logging into cPanel, another MySQL Databases icon will appear next to the phpMyAdmin icon; click on it.

This will lead you to the database list page.

In the action column you can find the delete database option to delete your database!

Answer 2

In phpMyAdmin 4.1.9 :

database_name > Operations > Remove database

Answer 3

• Go to the phpmyadmin homepage.
• Click Databases.
• Select the database you want to delete. (tick)
• Click Discard.

Answer 4

Taking the line from michael's answer above, I was unable to find the DROP Database command on my phpMyAdmin console in localhost .

Obviously, I didn’t have the setting. Go to the config.inc.php file of the phpMyAdmin folder and add the following:

$cfg['AllowUserDropDatabase'] = true;

Save and restart the local server, and the command will appear inside the console.

Answer 5

You can delete the database in cpanel.

In Cpanel, go to the databases, and there you will see all the created databases, and you can delete this database.

http://docs.cpanel.net/twiki/bin/view/AllDocumentation/CpanelDocs/MySQLDatabases#Delete Database

or another wise on a real server, if the user has privileges, you can run the command on the sql tab phpmyadmin.

 drop database databasename; 

Answer 6

database database name → Operations → Delete database → click on delete database (DROP)

Answer 7

You can follow uploaded images

Then select which database you want to delete.

Answer 8

How to delete a database in phpMyAdmin?

On the Database Operations tab, find (and click) the text Drop the database (DROP) .

Answer 9

Select the database on the left. Then on the right center vertex you can find “Operations”. In this go to delete the database (DROP). It's all.

Answer 10

The delete / delete option in operations is not available in my version.

Go to CPanel -> MySQLDatabase (the icon next to PhPMyAdmin) -> check that the DB will be deleted -> delete.

Answer 11

Go to the operations tab for the selected database and click "Delete Database (DROP)" to delete it.

Answer 12

There are two ways to delete a database.

1. Run this SQL query -> DROP DATABASE database_name
2. Click dbname → Operations → Delete Database

Answer 13

Open Terminal and run

  mysql -u root -p 

Password is null or just enter your mysql password

Ather just run this query

  DROP DATABASE DBname; 

---

If you are using phpmyadmin just run

  DROP DATABASE DBname; 

Answer 14

1. connect to the local host. 2. Open your favorite browser. 3. Verify that your local host is running. 4.type in url = localhost. 5. Collapse down click on phpadmin 6.once phpadmin is open. 7. Click on the database. 8.mark check the database you want to delete. 9. Click on the drops. • The database should be deleted. If this does not work 10. Click on 11.go database to work. 12.click drop database • should be displayed in red text •.

Answer 15

If you want to remove your database from phpmyAdmin or mySQl. Just go into the SQL command and write the command "drop DATABASE databasename;"

Example: drop DATABASE rainbowonlineshopping;

Then click the Go button. Your database will be deleted and you will receive this information.