Use the DROP DATABASE command to drop a database completely. Use this command with extreme cautionyou cannot recover a dropped database unless you have a backup.
To drop the greekdb database, issue the following command:
mysql> DROP DATABASE greekdb; Query OK, 0 rows affected (0.00 sec)
Similar to CREATE DATABASE IF NOT EXISTS, you can use DROP DATABASE IF EXISTS to suppress an error if you try to drop a nonexistent database.