【已解决】[图文步骤] message from server: “Host ‘172.17.0.1‘ is not allowed to connect to this MySQL server“

null,  message from server: "Host '172.17.0.1' is not allowed to connect to this MySQL server"

docker pull mysql:5.7

docker run -p 3306:3306 --name mysql-container -e MYSQL_ROOT_PASSWORD=123456  -d  mysql/mysql-server:5.7

docker ps

docker ps

docker exec -it  你的容器id bash

mysql -u root -p

show databases ;

use mysql ;

show tables ;

select Host, User  from user ;

update user set Host='%' where User='root' ;

flush privileges ;