CREATE USER ‘user1’@’localhost’ IDENTIFIED BY ‘pass1’;

GRANT SELECT,INSERT,UPDATE,DELETE ON *.* TO ‘user1’@’localhost’;

Source http://www.databasef1.com/tutorial/mysql-create-user.html