Add user to MySQL database

CREATE USER 'username'@'%' IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON `databasename`.* TO 'username'@'%';
FLUSH PRIVILEGES;