How to delete database from shell/command line?

[Dipak Bhoi]

Hello folks,

It's easy to delete database from phpMyAdmin but below is a command which helps you to delete database through shell.

Login to server via ssh and access mysql> prompt and hit command as below:

mysql>DROP DATABASE mydata_database;

You can alos verify database is deleted or not run below command.

mysql> SHOW DATABASES;

That's all.

Enjoy !!!