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;

mysql create database

To delete a database, use

drop database DB_NAME;
Need help with Linux Server or WordPress? We can help!

Leave a Reply

Your email address will not be published. Required fields are marked *