ERROR 1130 (HY000): Host ‘x.x.x.x‘ is not allowed to connect to this MySQL server

远程登录mysql时报错。
1：修改mysql表

mysql -u root -h127.0.0.1 -p
Enter password:
mysql>use mysql;
mysql>update user set host = '%' where user = 'root';
mysql>flush privileges;
mysql>select host, user from user;
mysql>quit

2：重启mysql

systemctl restart mysqld