MySQL: Create Database

mysql-create-database.sql.tpl

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

-- Alternatively, you can use ‘CREATE SCHEMA’ instead of ‘CREATE DATABASE’:
-- CREATE SCHEMA `mydb` CHARACTER SET utf8 COLLATE utf8_general_ci;
-- GRANT ALL ON `mydb`.* TO `username`@localhost IDENTIFIED BY 'password';
-- FLUSH PRIVILEGES;