How to Delete Database in MySQL!

        In MySQL we have learnt about how to add database but before adding database we must know about how to delete database in MySQL. It will help to remove unnecessary databases and users from the MySQL databases. To perform this work go through the method described down below -

Step - 1 :

Open terminal by pressing CTRL+Alt+T

Step - 2 :

Log in to MySQL

mysql -u root -p

Step - 3 :

Enter MySQL database password

Step - 4 :

View created databases

SHOW DATABASES;

Step - 5 :

Delete the target database

DROP DATABASE databasename;

Step - 6 :

Verify Deleted databases

SHOW DATABASES;

Step - 7 :

Log out

QUIT;