Step 1: Create User
mysql > CREATE USER 'newuser'@'localhost' IDENTIFIED BY 'password';
Step 2: Grant Privileges
mysql > GRANT ALL PRIVILEGES ON * . * TO 'newuser'@'localhost';
Step 3: Flush Privileges
mysql > FLUSH PRIVILEGES;
If you are having trouble accessing your mysql shell through your command prompt, you will have to add it to your PATH environment variable.