mysqladmin create {database}
CREATE USER '{username}r'@'localhost' IDENTIFIED BY '{password}';
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER, LOCK TABLES, CREATE TEMPORARY TABLES ON `{database}`.* TO '{username}'@'localhost' IDENTIFIED BY '{password}';