MySQL – Create database with collation and Character set utf8

If you want to create a database in MySQL with default charset and collate utf8, then you simply have to give the following command:

 

CREATE DATABASE "database_name"
 DEFAULT CHARACTER SET utf8
 DEFAULT COLLATE utf8_general_ci;