You probably created a database for testing or there is database that you don’t want to use so here is how you can delete it via SSH

First you will have to login to MySQL database by doing following command

mysql -u root -p

Now you will need to enter Password that you used while installation once logged. you should be able to perform deletion by doing following commands.

DROP DATABASE your_new_database;

At this point you might get the error like this

ERROR 1008 (HY000): Can’t drop database ‘new_database’; database doesn’t exist

in order to avoid this error and see if the database you trying to delete really exist, do following command instead.

DROP DATABASE IF EXISTS new_database;

If successfully deleted you should see this line.

Query OK, 0 rows affected, 1 warning (0.00 sec)

Now you can do following command in order to check if database was successfully deleted

SHOW DATABASES;

(Visited 7 times, 1 visits today)