Grant user authorization

Remote Host connection user authorization example: 192.168.1.111mysql server and 192.168.1.20.mysql Server

  Log on to MySQL at 192.168.1.111 and authorize the user

 

Query whether to add this user  
In this way, the management user with the MySQL login account user2 password 123456 is successfully authorized to the host with the IP address 192.168.1.112;   In this case, we connect to 192.168.1.112.   At this time, an error will be reported: the connection to the 192.168.1.111mysql server cannot be established. The reason is that the firewall for 192.168.1.111 is enabled, and you only need to disable the firewall.       Then connect to the 192.168.1.20.mysql server.     Authorization successful!

Grant user authorization