Create new DB and DB User in MySQL

gistfile1.txt

# DB
CREATE DATABASE wordpress;

# User
CREATE USER wordpressuser@localhost;

# User -> DB
SET PASSWORD FOR wordpressuser@localhost= PASSWORD("password");
GRANT ALL PRIVILEGES ON wordpress.* TO wordpressuser@localhost IDENTIFIED BY 'password';

# Apply
FLUSH PRIVILEGES;