1: Login to MySQL terminal as root
Mysql-uroot-pmysql
2: Create WX User, note password to add single quotation mark
Mysql> create user wx identified by ' WX ';
3: Create WX Database
Mysql>create database wx;
4: User WX authorized to have all the permissions of the WX database
Mysql> Grant all on wx.* to [e-mail protected] identified by ' WX ';
If you want to grant all permissions to user wx:
Mysql>grant all on * * to [e-mail protected]alhost identified by ' WX ';
5: Refresh the System Permissions table
mysql> flush Privileges;
6: Log out of root user to WX user
Mysql-uwx-pwx
View database information MySQL> show Databases; +--------------------+| Database |+--------------------+| information_schema | | wx |+--------------------+
7: Authorization to allow remote links
All hosts (%) with WX user login password are allowed to link access and grant all permissions:
' WX '@'%'wx'0 rows affected ( 0.00 sec)
Remote link Test
[Email protected]:~$ mysql-uwx-pwx-h Public network Ip-dwx
Mysql new user and authorized remote connection operation