Considering I have to do this every few months, I note this down:

create user username identified by 'password';
// Or you can do 
// GRANT ALL ON USERNAME.* TO 'DBNAME'@'HOSTNAME' IDENTIFIED BY 'PASSWORD';
GRANT SELECT, INSERT, UPDATE, DELETE ON USERNAME.* TO 'DBNAME'@'HOSTNAME' IDENTIFIED BY 'PASSWORD';
flush privileges;