Host is not allowed to connect to this MySQL server
这里碰到云服务器使用docker部署的mysql突然连接不上了,后台程序报错,navicat连接不上,报错信息为
Host is not allowed to connect to this MySQL server
经过查询得知,通过
docker exec -it mysql bash
进入mysql容器
mysql -uroot -p
输入密码登录mysql
use mysql
select host from user where user = 'root';
该结果表示是当前的root用户限制在当前的ip内访问的,需要修改他的访问域。
执行命令:
update user set host = '%' where user = 'root';
select host from user where user = 'root';
3.执行 FLUSH PRIVILEGES 或者重启 MySQL 即可;
flush privileges;
原文链接:https://blog.csdn.net/dhp1994/article/details/134212344