# 拉取镜像
docker pull mysql
# 启动容器(这里是8.0以上的)
docker run -p 3306:3306 --name mysql -e MYSQL_ROOT_PASSWORD=123456 -d mysql
连接mysql
sudo docker exec -it mysql bash
mysql -uroot -p123456
MySQL8.0设置远程访问权限
use mysql;
select host, user, authentication_string, plugin from user;
# 查看user表的root用户Host字段是localhost,说明root用户只能本地登录,现在把他改成远程登录
update user set host='%' where user='root';
# 所有操作后,应执行
FLUSH PRIVILEGES;
ALTER USER 'root'@'localhost' IDENTIFIED BY 'password' PASSWORD EXPIRE NEVER;
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';
# 新的密码 123456
ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '123456';
# 退出
exit