[报错：客户端不允许远程访问]MySQL said: Host '*.*.*.*' is not allowed to connect to this MySQL server解决办法

解决办法： 给所有主机开放权限

# mysql -h127.0.0.1 -u root -p

输入密码

>grant all privileges on *.* to root@"%" identified by "密码" WITH GRANT OPTION;

>FLUSH PRIVILEGES;

>grant all privileges on *.* to root@"xxx.xxx.xxx.xx" identified by "123456" WITH GRANT OPTION;

>FLUSH PRIVILEGES;

再在客户端访问，可进入：