MySQL cannot be a workaround from a remote connection (s not allowed to connect to this MySQL server) _mysql

This error occurs if you want to connect to your MySQL:

Copy Code code as follows:

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

Workaround:

1. Change Table method. Your account may not be allowed to log in remotely, only in localhost. This time as long as the computer in localhost, login mysql, change the "MySQL" Database in the "User" table in the "host" item, from "localhost" renamed "%"
Mysql-u root-pvmwaremysql>use mysql;mysql>update User Set host = '% ' where user = ' root '; Mysql>select host, use R from user;

2. Authorization law. For example, you want to myuser use MyPassword to connect to a MySQL server from any host.
Grant all privileges in *.* to ' myuser ' @ '% ' identified by ' MyPassword ' with GRANT OPTION;
If you want to allow the user to connect to the MySQL server from the IP-192.168.1.3 host, and use MyPassword as the password myuser
GRANT all privileges on *.* to ' myuser ' @ ' 192.168.1.3 ' identified by
' MyPassword ' with GRANT OPTION;