I always forget the MySQL create database with UTF8 character set syntax, so here it is:
CREATE DATABASE `mydb` CHARACTER SET utf8 COLLATE utf8_general_ci; GRANTALLON`mydb`.*TO`username`@localhost IDENTIFIED BY 'password'; |
Alternatively, you can use ‘CREATE SCHEMA’ instead of ‘CREATE DATABASE’:
CREATESCHEMA`mydb` CHARACTER SET utf8 COLLATE utf8_general_ci; GRANTALLON`mydb`.*TO`username`@localhost IDENTIFIED BY 'password'; |