docker安装mysql,支持远程登录

拉取mysql
docker pull mysql


运行docker容器
docker run -di --name wangjinlong_mysql -p 4406:3306 -e MYSQL_ROOT_PASSWORD=123456 mysql
其中4406才是我们连接的端口，3306是内部端口


进入bash
docker exec -it wangjinlong_mysql /bin/bash
登录mysql
mysql -u root -p 123456

docker inspect wangjinlong_mysql      运行状态



设置远程登录
grant all privileges on *.* to 'root'@'%';

ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '123456';


flush privileges;