How do I drop a MySQL database from the command line?

Question

From the command line interface, how can you remove or drop a database from MySQL or MariaDB?

Answer

First, log in to the Mysql server with the "MySQL" command.

From there, you can drop the database from the command line interface. The syntax the server expects is:

DROP {DATABASE | SCHEMA} [IF EXISTS] db_name

As an example of a user database:

mysql> drop database cptest_cptest;