MySQL Error: no.1130 error resolution

Tips for testing MySQL with SQLyog:

ERROR N0.1130 Host ' 192.168.100.111 ' is not allowed to connect to this MYSQL server

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M00/6D/CC/wKiom1VsAdig8J8RAAB-g30Pa6I714.jpg "title=" Qq20150601145447.png "alt=" Wkiom1vsadig8j8raab-g30pa6i714.jpg "/>

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 "%"

After MySQL, change "host" in "User" table in "MySQL" Database, rename "%" from "localhost"
Mysql-u root-p Root

Mysql>use MySQL;

Mysql>update User Set host = '% ' where user = ' root ';

Mysql>flush privileges;

Mysql>select host, user from user\g;

2. Authorization law.

For example, if you want to mysqladmin use MyPassword to connect to a MySQL server from any host.

GRANT All privileges on * * to' mysqladmin ' @ '% '  identified by ' MyPassword ' with GRANT OPTION;

If you want to allow users to connect to the MySQL server from a host myuser IP 192.168.1.3 and use MyPassword as the password

grant all privileges on * * TO  ' myuser ' @ ' 192.168.1.3 '  identified by ' MyPassword ' with GRANT OPTION;

This article from "Guangzhou, Rain People" blog, please be sure to keep this source http://liulihuan.blog.51cto.com/8018739/1657113

MySQL Error: no.1130 error resolution