How to Delete a Database in MySQL/MariaDB

Posted on by J. Mays | Updated:
Reading Time: 2 minutes

Getting Started

These instructions intend to show how to delete a database in MySQL. We will be working from a Liquid Web Core Managed Linux server with CentOS 7.

How to Delete A Database In MySQL/MariaDB

Video by Andrew Casares

First, we'll log in to the MySQL server from the command line as root with the following command.

mysql -u root -p

In this case, I've specified the user root with the -u flag and then used the -p flag, so MySQL prompts for a password. Enter your current password to complete the login. If you need to change your root (or any other) password in the database, follow this tutorial to change a password for MySQL via the command line.

You should now be at a MySQL prompt that looks very similar to this.

mysql>

Follow this tutorial if you have not yet created a database or you want a list of databases.

Delete a Database in MySQL

It only takes a straightforward command to delete a database in MySQL, but BEWARE; when you remove a MySQL database, you can not undo it! 

The following is the command to delete your database in MySQL. If the database tutorial_database exists, the command will altogether remove it.

DROP DATABASE tutorial_database;

If a database with the name tutorial_database does not exist, then you'll receive this error.

ERROR 1008 (HY000): Can't drop database 'tutorial_database'; database doesn't exist

To avoid seeing this error use the following command instead.

DROP DATABASE IF EXISTS tutorial_database;

The above command will only drop the database tutorial_database if a database of that name exists.

Get 75% off a VPS!

View All MySQL Databases

To view a list of databases, simply issue the following command.

SHOW DATABASES;

Your result should be similar to this.

mysql> SHOW DATABASES;
 +--------------------+
 | Database           |
 +--------------------+
 | information_schema |
 | mysql              |
 | test               |
 +--------------------+
 4 rows in set (0.00 sec)

Conclusion

In this tutorial, we covered how to delete a MySQL database from the command line in Linux. We also showed how to view your databases as well. If you prefer a visual tutorial, we included a handy video that presents a visual representation of removing your MySQL database.

Liquid Web customers also receive 24/7/365 support from our team of knowledgeable Linux administrators. If you need a new server from a trusted managed hosting provider, chat with our sales team to find the right fit for your needs.

Series Navigation
<< Previous ArticleNext Article >>

About the Author: J. Mays

Have Some Questions?

Our Sales and Support teams are available 24 hours by phone or e-mail to assist.

1.800.580.4985
1.517.322.0434

Latest Articles

5 Alternatives to GitHub

Read Article

5 Steps to Install and Configure osquery on CentOS 7 & 8

Read Article

Five Steps to Create a Robots.txt File for Your Website

Read Article

Premium Business Email Pricing FAQ

Read Article

Microsoft Exchange Server Security Update

Read Article