Mysql new user and authorized remote connection operation

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