解决办法： 给所有主机开放权限
# mysql -host 127.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;
再在客户端访问，可进入：
[报错：客户端不允许远程访问]MySQL said: Host '*.*.*.*' is not allowed to connect to this MySQL server解决办法
原文：https://www.cnblogs.com/Tanwheey/p/13321735.html