How to Delete a MySQL Database

Written by Jack Lloyd

Last Updated: August 25, 2022

This wikiHow teaches you how to use your computer's command line to delete a MySQL database. In order to delete a MySQL database, you must have access to an account with delete privileges, such as the "root" account.

Steps

Download Article

{"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/1\/1c\/1035787-1.jpg\/v4-460px-1035787-1.jpg","bigUrl":"\/images\/thumb\/1\/1c\/1035787-1.jpg\/aid1035787-v4-728px-1035787-1.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>Image by: Uploader<br>\nLicense: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/creativecommons.org\/licenses\/by\/3.0\/\">Creative Commons<\/a>\n<\/p><\/div>"}

Open the MySQL Command Line . In order to delete a database in MySQL, you'll need to use the MySQL command line from your computer's Command Prompt (Windows) or Terminal (Mac) program.
{"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/1\/10\/1035787-2.jpg\/v4-460px-1035787-2.jpg","bigUrl":"\/images\/thumb\/1\/10\/1035787-2.jpg\/aid1035787-v4-728px-1035787-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>Image by: Uploader<br>\nLicense: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/creativecommons.org\/licenses\/by\/3.0\/\">Creative Commons<\/a>\n<\/p><\/div>"}

2
Enter the login command. Type in the following, then press ↵ Enter .
```
 mysql 
 - 
 u 
 root 
 - 
 p 
```
- If you don't have access to the root account, enter your own username in place of "root". This must be an account that has read/write privileges.
Advertisement
{"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/a\/a8\/1035787-3.jpg\/v4-460px-1035787-3.jpg","bigUrl":"\/images\/thumb\/a\/a8\/1035787-3.jpg\/aid1035787-v4-728px-1035787-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>Image by: Uploader<br>\nLicense: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/creativecommons.org\/licenses\/by\/3.0\/\">Creative Commons<\/a>\n<\/p><\/div>"}

Type in the password you use to log into MySQL, then press ↵ Enter .
{"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/5\/58\/1035787-4.jpg\/v4-460px-1035787-4.jpg","bigUrl":"\/images\/thumb\/5\/58\/1035787-4.jpg\/aid1035787-v4-728px-1035787-4.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>Image by: Uploader<br>\nLicense: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/creativecommons.org\/licenses\/by\/3.0\/\">Creative Commons<\/a>\n<\/p><\/div>"}

4
View a list of your databases. Once MySQL opens, type in the following command and press ↵ Enter to see a list of your MySQL databases:
```
 SHOW 
 DATABASES 
 ; 
```
{"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/2\/2f\/1035787-5.jpg\/v4-460px-1035787-5.jpg","bigUrl":"\/images\/thumb\/2\/2f\/1035787-5.jpg\/aid1035787-v4-728px-1035787-5.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>Image by: Uploader<br>\nLicense: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/creativecommons.org\/licenses\/by\/3.0\/\">Creative Commons<\/a>\n<\/p><\/div>"}

5
Find the name of the database you want to delete. Scroll through the databases until you find the one you want to delete, making sure to note its name as it appears above the database. ^{[1]
X
Research source}
- If you're using a Mac, database names are case-sensitive. This means that if the database's name has capital letters, you'll need to use the proper capitalization in the "delete" command to make sure you delete the correct database.
{"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/8\/85\/1035787-6.jpg\/v4-460px-1035787-6.jpg","bigUrl":"\/images\/thumb\/8\/85\/1035787-6.jpg\/aid1035787-v4-728px-1035787-6.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>Image by: Uploader<br>\nLicense: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/creativecommons.org\/licenses\/by\/3.0\/\">Creative Commons<\/a>\n<\/p><\/div>"}

6
Delete the database. Type in DROP DATABASE name; where name is your database's name, then press ↵ Enter . For example, to delete a database named "Flowers", you would enter the following command:
```
 DROP 
 DATABASE 
 Flowers 
 ; 
```
{"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/3\/35\/1035787-7.jpg\/v4-460px-1035787-7.jpg","bigUrl":"\/images\/thumb\/3\/35\/1035787-7.jpg\/aid1035787-v4-728px-1035787-7.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>Image by: Uploader<br>\nLicense: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/creativecommons.org\/licenses\/by\/3.0\/\">Creative Commons<\/a>\n<\/p><\/div>"}

You can ensure that the database was deleted by re-entering the SHOW DATABASES; command and scrolling through your available databases. The one you deleted should not be present.

Community Q&A

Search

Add New Question

Question

What does it mean if I get "Error 1010 (HY000): Error dropping database (can't rmdir './xxxxxx', errno: 39)"?

Community Answer

You have to stop the database, go to datadir, remove that database manually and restart the database.

Thanks! We're glad this was helpful.
Thank you for your feedback.
If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
Yes No

Not Helpful 6 Helpful 8
Question

Why does a dropped database still appear and run in Workbench in the MySQL monitor?

Community Answer

Try "sudo service mysql restart." If your MySQL service is named something else, you may have to change the command accordingly. You can also try "sudo /etc/init.d/mysql restart."

Thanks! We're glad this was helpful.
Thank you for your feedback.
If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
Yes No

Not Helpful 8 Helpful 3

Ask a Question

200 characters left

Include your email address to get a message when this question is answered.

Submit

Video

Tips

If you aren't sure whether or not the database exists, entering DROP DATABASE IF EXISTS name; will prevent an error from displaying if the database isn't registered.

Thanks
Helpful 0 Not Helpful 0
In the unlikely event that you're deleting a database from a server not using localhost, you'll type the login command as mysql -u root -h host -p where "host" is the IP address of your server.

Thanks
Helpful 0 Not Helpful 0

Submit a Tip

All tip submissions are carefully reviewed before being published

Submit

Thanks for submitting a tip for review!

Warnings

Not all users have read/write privileges. Make sure you're using an account that allows you to delete databases (e.g., the root account).

Thanks
Helpful 0 Not Helpful 0

You Might Also Like

[1]

Log in

How to Delete a MySQL Database

Steps

Community Q&A

Video

Tips

Warnings

You Might Also Like

References

About This Article

Is this article up to date?

Quizzes

You Might Also Like

Featured Articles

Trending Articles

Featured Articles

Featured Articles

Watch Articles

Trending Articles

Explore Categories