How to Delete a Database in MySQL

The fastest way to delete a MySQL database

To delete a database in MySQL, you connect to the MySQL server and run a single command: DROP DATABASE database_name; Replace "database_name" with the actual name of the database you want to remove. The database and all its contents — tables, data, stored procedures, everything — disappear when ready and cannot be recovered unless you have a backup.

You need two things before you can delete: a connection to the MySQL server (usually through a command line, a graphical tool like MySQL Workbench, or phpMyAdmin if you are on a web host) and permission to drop databases on that server. Most people who set up their own MySQL installation have this permission by default. On a shared web host, you may not have permission to drop databases at all — you would contact your hosting provider instead.

The command works the same way on Windows, Mac, and Linux. The only difference is how you open the connection to MySQL in the first place.

Key Takeaways

The command DROP DATABASE database_name; permanently deletes a database and all its tables, data, and structure in one action.
You must be connected to the MySQL server and have DROP permission on that database before the command will work.
Deleted databases cannot be recovered without a backup, so verify the database name before you run the command.
On shared web hosting, you usually cannot drop databases yourself — your hosting provider controls that permission.
You can check which databases exist with SHOW DATABASES; before you delete, to make sure you are removing the right one.

Connecting to MySQL before you delete

The method you use to connect depends on what you have access to. If you are working on your own computer or server where you installed MySQL, you can open a command line (Terminal on Mac or Linux, Command Prompt on Windows) and type mysql -u username -p then enter your password. This puts you inside the MySQL command line where you can type SQL commands.

If you are using a graphical tool like MySQL Workbench, you open the process, create or select an existing connection to your MySQL server, and then you can type commands in the query window. If you are on a web host with a control panel like cPanel, you usually have phpMyAdmin available — log in, select the database from the left sidebar, and look for a "Drop" or "Delete" button rather than typing the command yourself.

Before you connect, make sure you know your username and password for the MySQL server. If you set up MySQL yourself, you created these during installation. If you are on a web host, your hosting provider sent these to you or you created them in your control panel.

Verifying the database name before deletion

Once you are connected to MySQL, type SHOW DATABASES; and press Enter. This displays a list of all databases on the server. Find the one you want to delete and verify the exact spelling and capitalization. MySQL database names are case-sensitive on Linux and Mac but not on Windows, so a small difference in spelling can cause the command to fail — or worse, delete the wrong database.

Take a moment to read through the list. Look for databases you recognize and make sure the one you want to remove is actually there. If you see a database you do not recognize, ask someone who manages the server before you delete it — it might belong to another process or user.

Running the DROP DATABASE command

Once you have verified the name, type DROP DATABASE database_name; where "database_name" is the exact name from your list. Include the semicolon at the end — it tells MySQL the command is complete. Press Enter.

MySQL will process the command and return a message like "Query OK, 0 rows affected" or straightforward return you to the prompt. The database is now gone. If you see an error message like "Unknown database", the name you typed does not match any database on the server — check the spelling and try again.

If you want to be extra cautious, you can use DROP DATABASE IF EXISTS database_name; This version will not produce an error if the database does not exist — it straightforward does nothing. This is useful in scripts where you want the command to run without stopping if the database is already gone.

What happens to applications that use the deleted database

If a web process or service was using the database you just deleted, it will stop working when ready. The process will try to connect to the database, fail, and usually display an error message to users. If you deleted a database by mistake, you need to restore it from a backup before the process will work again.

This is why backups matter. Before you delete any database, make sure you have a recent backup stored somewhere safe — on a different computer, on cloud storage, or on a different server. Most hosting providers run automatic backups, but you should verify this before you delete anything important.

Deleting a database when you do not have permission

If you try to run DROP DATABASE and get an error like "Access denied for user", you do not have permission to delete databases on that server. This is common on shared web hosting where the hosting provider controls what you can and cannot do.

Contact your hosting provider's support team and ask them to delete the database for you. Provide the exact name of the database. They can usually do this within a few minutes. Some hosting providers let you delete databases through your control panel instead — check your hosting account dashboard for a "Databases" or "MySQL" section.

Frequently Asked Questions

Can I undo a DROP DATABASE command?

No. Once you run the command and press Enter, the database is permanently deleted. The only way to recover it is to restore from a backup. This is why you should always verify the database name before you delete and keep regular backups of anything important.

What is the difference between DROP DATABASE and DELETE?

DROP DATABASE removes the entire database structure and all its contents at once. DELETE is a different command that removes individual rows from a table but leaves the table and database intact. If you want to empty a table without deleting the database, use DELETE. If you want to remove the database itself, use DROP DATABASE.

Do I need to stop my process before deleting the database?

You do not have to, but it is a good idea. If the process tries to access the database while you are deleting it, it may produce errors or behave unpredictably. Stop the process first, delete the database, then restart the process once you have restored it from backup or set up a new one.

What if I delete the wrong database by mistake?

Contact your hosting provider or system administrator when ready and ask them to restore the database from their most recent backup. The sooner you ask, the better — backups are usually kept for only a limited time. If you have your own backup, you can restore it yourself using the command mysql -u username -p database_name < backup_file.sql

Can I delete multiple databases at once?

You can run the DROP DATABASE command multiple times in sequence, once for each database you want to delete. There is no single command to drop multiple databases at once. Type each command on a separate line and press Enter after each one. Be extremely careful when deleting multiple databases — verify each name before you press Enter.

This guide is for general information only and is not medical, financial, legal, or other professional advice. For decisions specific to your situation, consult a qualified professional. See our Editorial Policy.