ERROR 1130:host ***.***.***.*** isn't allowed to connect to this MySQL server
Indicates that the connected user account does not have remote connection permissions and can only log on natively (localhost). You need to change the host entry in the user table in the MySQL database
Rename localhost to%
Specific steps: Login to MySQL first use MySQL;
There was an error when the update was provided in the other way.
mysql> Update user set host= '% ' where user = ' root ';
ERROR 1062 (23000): Duplicate entry '%-root ' for key ' PRIMARY '
The host information for the following database is then viewed as follows:
Mysql> Select host from user where user = ' root ';
+-----------------------+
|host|
+-----------------------+
|% |
| 127.0.0.1 |
| Localhost.localdomain |
+-----------------------+
3 The rows in Set (0.00 sec) Host already has this value, so run the command directly:
The code is as follows: Mysql>flush privileges;
Then connect with mysql-uroot-h***.***.***.*** ... Success!!
This article refer to http://www.jb51.net/article/31902.htm
Remote MySQL Error 1130 (HY000): Host ' 172.17.42.1 ' is not allowed to connect to this MySQL server