技术交流QQ群
933925017
docker创建的mysql不能连接
docker Host is not allowed to connect to this mysql server
1.创建mysql容器
docker run -d -v /channel/data:/var/lib/mysql --privileged --name mysql-channel -p 3308:3306 -e MYSQL_ROOT_PASSWORD=123 --restart=always mysql/mysql-server:5.7.25
2.进入容器更改权限
docker exec -it mysql bash
mysql -uroot -p123
use mysql;
update user set host = '%' where user ='root';
flush privileges;
quit;