Manually create a new MySQL user account

1. Log on to MySQL as root.
2. Grant permission:
mysql> GRANT ALL PRIVILEGES ON *.* TO 'monty'@'localhost'
-> IDENTIFIED BY 'some_pass' WITH GRANT OPTION;
3. If encountered error 'Client does not support authentication protocol requested by server; consider upgrading MySQL client', try using
mysql> SET PASSWORD FOR
-> 'some_user'@'some_host' = OLD_PASSWORD('newpwd');