Delete MySQL Database From Command Line

Here is how to delete MySQL database from Command Line Interface or SSH using MySQL drop database command. It is quite simple and easy. Previously, we have shown how to export WordPress MySQL Database on Rackspace Deployment using only Command Line Interface. MySQL by default has quite powerful interactive interface. PHPMyAdmin is a risk itself if run for production environment. Before the reader is going to delete MySQL database from Command Line, we recommend to take a backup of the whole server although if properly done, this can not be a risk to other databases.

 

Commands to Delete MySQL Database From Command Line

 

For example, in the guide for installing Piwik on nginx on Ubuntu 14.04 on Rackspace Cloud, we really installed Piwik on production environment and understood it is far from our expectation. Only recursively deleting the web software is not a good idea for security reasons. If you have old MySQL database, make sure the name is correct. References can be found here :

 

First, SSH to the database server as server’s root user. MySQL root user might have different password. This command to login to MySQL as root usually works fine :

The syntax to delete MySQL database is :

But we will run this to get the list of all databases :

It will return thing like this :

You want to delete that database named your-db-to-delete; in that case you’ll run :

Again reload the databases :

And flash the privileges :

If you had an user WHO WAS THE ONLY USER OF THAT INTENDED TO DELETE DATABASE, you must delete it too :

Again flush the privileges.