docker-mysql本地连接不上问题解决

1.查看容器

docker container ls

2.进入容器

docker exec -it 容器id bash

3.登录mysql

mysql -h localhost -u root -p

4.授权

mysql8.0以下

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'root' WITH GRANT OPTION;

mysql8.0

grant all privileges on *.* to 'root'@'%' ;

刷新

flush privileges;