Remote User connection to mysql authorization

Remote User connection to mysql authorization method: www.2cto.com run on the machine where mysql is installed: 1, d: \ mysql \ bin \> mysql-h localhost-u root // enter MySQL Server 2, mysql> grant all privileges on *. * TO 'root' @ '%' with grant option // GRANT data access permissions TO any host. For example, if you want myuser TO use mypassword TO connect TO the mysql server from any host. Grant all privileges on *. * TO 'myuser' @ '%' identified by 'mypassword' with grant option; if you want TO allow myuser TO connect TO the mysql server from a host WITH ip address 192.168.1.6, and use mypassword as the password grant all privileges on *. * TO 'myuser' @ '192. 168.1.3 'identified BY 'mypassword' with grant option; 3. mysql> flush privileges // The modification takes effect. 4. mysql> EXIT