Docker部署Mysql
1.拉取镜像
docker pull mysql:[版本号]
当前安装mysql5.6,执行docker pull mysql:5.6
2.查看镜像
docker images
3.启动镜像
docker run -d -p 3306:3306 -v [本地目录]:[容器目录] -e MYSQL_ROOT_PASSWORD=[设置密码] --name [设置容器名] mysql:[拉取的镜像版本号]
docker run -d -p 3306:3306 -v /root/docker_mount/mysql_5.6/node_01/conf:/etc/mysql/ -v /root/docker_mount/mysql_5.6/node_01/data:/var/lib/mysql -v /root/docker_mount/mysql_5.6/node_01/logs:/logs -e MYSQL_ROOT_PASSWORD=123456 --name mysql5.6_node01 mysql:5.6
[外链图片转存失败,源站可能有防盗链机制,建议将图片保存下来直接上传(img-ECLgJrnQ-1683862562110)(docker安装Mysql.assets/image-20230512104356913.png)]
4.查看是否启动
docker ps
5.进入容器内设置远程连接
docker exec -it [容器名] /bin/bash
1.进入容器内
docker exec -it mysql5.6_node01 /bin/bash
2.登录mysql
mysql -u root -p, 此时提示输入密码,输入密码即可进入
3.开启远程连接
use mysql;
select Host,User from user;
此时查看到存在Host允许为任意ip访问root用户。
如果没有则需要以下命令赋予权限:
GRANT ALL PRIVILEGES ON . TO ‘root’@‘%’ IDENTIFIED BY ‘password’ WITH GRANT OPTION;
ES ON . TO ‘root’@‘%’ IDENTIFIED BY ‘password’ WITH GRANT OPTION;
FLUSH PRIVILEGES;