Cacher is the code snippet organizer for pro developers

CREATE USER 'username'@'localhost' IDENTIFIED BY 'password';

-- another way of creating the user
CREATE USER
  user_name IDENTIFIED BY [ PASSWORD ] 'password_value';