Create a MySQL User

Simply Shell command to create a mysql user.

shell> mysql –user=username –password=password

mysql> CREATE USER ‘monty’@'%’ IDENTIFIED BY ‘some_pass’;
mysql> GRANT ALL PRIVILEGES ON *.* TO ‘monty’@'%’ WITH GRANT OPTION;