You can use the DROP DATABASE statement to delete a database.

Syntax

drop_database_stmt:
    DROP DATABASE [IF EXISTS] database_name;

Parameters

Parameter Description
IF EXISTS This parameter is used to mitigate errors that occur when you delete a database that does not exist.
database_name The name of the database that you want to delete.

Examples

Use the following statements to delete a database that is named test:
drop database test;
Query OK, 0 rows affected (0.03 sec)

drop database if exists test;
Query OK, 0 rows affected, 1 warning (0.00 sec)