Setup a new database and database user

mysql-new-db-snippet

CREATE DATABASE db_name;
GRANT USAGE ON *.* TO 'db_user'@'hostname' IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON db_name.* TO 'db_user'@'hostname';

# Shorter
create database db_name;
grant all on db_name.* to 'db_user' identified by 'password';
flush privileges;