Resolution NAVICAT Error: 1130-host is not allowed MySQL does not allow remote access from the method

ERROR 1130:host ' 192.168.1.3 ' isn't allowed to connect to Thismysql server    Workaround:  1. Change the table method. It may be that your account is not allowed to log on remotely, only on localhost. This time, as long as the computer on the localhost, log in to MySQL, change the "MySQL" Database in the "User" table "host", from "localhost" to "%"

Run on the machine where MySQL is installed: mysql-u root-pvmwaremysql>usemysql;mysql>update user Set host = '% ' where user = ' root '; mysql>se Lect host, user from user; 1, d:/mysql/bin/>mysql-h localhost-u root//This should be able to enter MySQL server 2, mysql>grant all privileges on * * to ' root ' @ '% ' with Grant OPTION//grants any host access to data 3, Mysql>flush privileges//Modify effective 4, Mysql>exit//exit MySQL server

Resolution NAVICAT Error: 1130-host is not allowed MySQL does not allow remote access from the method