Setting up a new MySQL user account with grant permission

[cah]

Code: Select all

$ mysql -u<rootuser> -p<rootuser_password>
mysql> GRANT ALL PRIVILEGES ON *.* TO '<username>'@'%' IDENTIFIED BY '<password>' WITH GRANT OPTION;
Query OK, 0 rows affected (0.00 sec)