Today on Linux installed MySQL, but found in the local login can, but remote login error
ERROR 1130:host ' 192.168.1.3 ' isn't allowed to connect to this MySQL server
First of all, the error is that our MySQL is not allowed to Telnet, so telnet failed, the workaround is as follows:
1. Log on to the mysql:mysql-uroot-p password on the MySQL-equipped machine
2. Select my MySQL library, execute the use MySQL;
3. Update the user table to perform update user set host = '% ' where user = ' root '; This sentence may be error-free.
4. Implementation of the flush privileges;
After 4 steps above, you can solve this problem.
Note: The fourth step is to refresh the MySQL permissions related tables, must not forget, I did not perform the first time fourth step, the results have been unsuccessful, finally found this reason.
Host is not allowed to connect to this MySQL server workaround