MySQL create database

To create a database, you can use

create database DB_NAME;

Example

To create a database with specific charset use

create database DB_NAME character set utf8mb4 collate utf8mb4_bin

Or

create database DB_NAME character set utf8mb4 collate utf8mb4_unicode_ci;

You can use whatever character set you wish instead of utf8mb4.

Example

create database serverok_db2 character set utf8mb4 collate utf8mb4_unicode_ci;

To delete a database, use

drop database DB_NAME;