MySQL create database

To create a database, you can use

create database DB_NAME;

1	create database DB_NAME;

Example

To create a database with specific charset use

create database DB_NAME character set utf8mb4 collate utf8mb4_bin

1	create database DB_NAME character set utf8mb4 collate utf8mb4_bin

create database DB_NAME character set utf8mb4 collate utf8mb4_unicode_ci;

1	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;

1	create database serverok_db2 character set utf8mb4 collate utf8mb4_unicode_ci;

mysql create database

To delete a database, use

drop database DB_NAME;

1	drop database DB_NAME;