MySQL 创建数据库并指定字符集编码

备忘

CREATE DATABASE mydb CHARACTER SET utf8 COLLATE utf8_general_ci;
GRANT ALL ON mydb.* TO "username"@"%" IDENTIFIED BY "password";
FLUSH PRIVILEGES;