【docker】Host is not allowed to connect to this MySQL server

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.youkuaiyun.com/dhp1994/article/details/134212344