SQL DROP DATABASE  can be used to delete databases .

Example

mysql> DROP DATABASE database_name;
Query OK, 1 row affected (0.54 sec)