[报错:客户端不允许远程访问]MySQL said: Host '*.*.*.*' is not allowed to connect to this MySQL server解决办法
2020-07-16 11:29 Tanwheey 阅读(225) 评论(0) 编辑 收藏 举报
解决办法: 给所有主机开放权限
# mysql -h127.0.0.1 -u root -p
输入密码
>grant all privileges on *.* to root@"127.0.0.1" identified by "密码" WITH GRANT OPTION;
>FLUSH PRIVILEGES;
>grant all privileges on *.* to root@"%" identified by "密码" WITH GRANT OPTION;
>FLUSH PRIVILEGES;
>grant all privileges on *.* to root@"xxx.xxx.xxx.xxx" identified by "123456" WITH GRANT OPTION;
>FLUSH PRIVILEGES;
再在客户端访问,可进入: