Error MySQL 1130 solution by Navicat for MySQL remote connection

with Navicat Connect Remote MYSQL , prompting the following error, I thought it was my own firewall problem, but shut down, still not.

ERROR 1130:host ' 192.168.1.3 ' isn't allowed to connect to Thismysql server

In fact, the main problem is the MySQL server side of the permissions problem, the default is to allow only local localhost login, so the remote is denied, the solution is to be authorized on the MySQL server.

Full operation:

1. On the MySQL server: Start-and-run->cmd

2. cd MySQL installation directory \ Bin

3. mysql-uroot-p1234;

4. Mysql> Grant all privileges on * * to ' root ' @ '% ' identified by ' 1234 ' with GRANT OPTION;

5. mysql> flush Privileges;

All Privileges:select,insert,update,delete permissions for this category

*. *: The first * represents the DB, the second * represents the table

' Root ' @ '% ': root indicates that user,% represents the host

' 1234 ': Indicates the user's corresponding password

Error MySQL 1130 solution by Navicat for MySQL remote connection