How do you add a database in MySQL?

In MySQL, you can use the CREATE DATABASE statement to add a database.

Here is the grammar structure:

CREATE DATABASE database_name;

The database_name is the name of the database to be added.

For example, to add a database named mydatabase, you can use the following command:

CREATE DATABASE mydatabase;

Please note that in MySQL, database names are case-sensitive.