Create New MySQL Database (with user)

create-mysql-db.sql

-- Using GRANT for creating new users has been deprecated and will be removed in the future
-- as of 5.7.1

-- Create a new user
create user '[username]'@'[host]' identified by '[password]';

-- Create a new database/user
create database [schema];

-- Grant user access to database
grant all on [schema].* to '[username]'@'[host]' identified by '[password]';