MySQL Remote login error correction

Telnet to the Linux server above MySQL, there are two minor errors:

1:10,060 Error Server firewall on state

Setup-> shut down the firewall (sometimes you may not find the related settings and need to install the relevant management software)

2: Host is not allowed to connect to thisMySQL server

This error is caused by MySQL not allowing remote logins

Technically logged in MySQL account does not allow remote login

Workaround:

1, in the machine equipped with MySQL login mysql:mysql-uroot-p (can be used putty and other software remote login);

2, use MySQL;

3, update user set host = ‘%‘ where user = ‘root‘; the execution of this sentence may be an error, do not control it;

4, Execution FLUSH PRIVILEGES; (this step is to refresh the MySQL related permissions table, it is important, easy to forget)

　　

MySQL Remote login error correction