How to create a MySQL user and assign it to a databases.

new-database-with-user.sql

# ~1~ = Datbase Name 
# ~2~ = New MySQL username 
# ~3~ = The new users password

# Create a database
CREATE DATABASE `~1~`;

# Create a user
CREATE USER '~2~'@'localhost' IDENTIFIED BY '~3~';

# Assign it the new database
GRANT ALL PRIVILEGES ON `~1~`.* TO '~2~'@'localhost';

# Reload privilegs
FLUSH PRIVILEGES;


# SAMPLE
CREATE DATABASE `DB_NAME`;
CREATE USER 'DB_USERNAME'@'localhost' IDENTIFIED BY 'DB_PASSWORD';
GRANT ALL PRIVILEGES ON `DB_NAME`.* TO 'DB_USERNAME'@'localhost';
FLUSH PRIVILEGES;