Setting up a new MySQL user account with grant permission
Posted: Wed Jun 08, 2016 5:09 pm
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)