MySQL Create User and Grant Privileges

GRANT ALL PRIVILEGES ON mydatabase.* TO 'my_new_user'@'localhost' IDENTIFIED BY 'a great password';

Creates user and gives them privileges at once. Probably follow up with FLUSH PRIVILEGES