Create database and user in MySQL

-- Access via shell $ mysql -u root -p
 
-- Create DB 
CREATE DATABASE databasename;
 
-- Create User
GRANT ALL PRIVILEGES ON databasename.* TO "wordpressusername"@"%" IDENTIFIED BY "password";
 
-- Flush
FLUSH PRIVILEGES;
 
-- exit
EXIT