# pull mysql
docker pull mysql
# 创建容器运行,指定端口,设置mysql密码,注意MYSQ_ROOT_PASSWORD的大写,改为小写,run后的容器直接就是Exited状态
docker run --name mysql -p 3306:3306 -e MYSQ_ROOT_PASSWORD=root -d mysql
# 进入容器
docker exec -it mysql /bin/bash
# 登录mysql, -u 后是账号,-p 后是密码
mysql -uroot -proot
# 选择mysql库
use mysql
# 查看root信息
select host,user from user;
+-----------+------------------+
| host | user |
+-----------+------------------+
| % | root |
| localhost | mysql.infoschema |
| localhost | mysql.session |
| localhost | mysql.sys |
| localhost | root |
+-----------+------------------+
5 rows in set (0.00 sec)
# 查看 root 的host 如果你是localhost,执行如下:
update mysql.user set host = '%' where user = 'root';
# 设置远程连接权限, 注意语句中的大小写
alert user 'root'@'%' IDENTIFIED WITH mysql_native_password BY 'root';
# 刷新权限
flush privileges;
docker 中mysql容器设置远程连接
最新推荐文章于 2024-05-11 16:32:20 发布