Use the DROP DATABASE command to drop a database completely. Use this command with extreme caution—you cannot recover a dropped database unless you have a backup.
A user must have the DROP privilege in order to drop a database. Grant this privilege sparingly.
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.