docker自定义安装mysql 5.7

小灰灰 2023-07-02 11:23 24阅读 0赞

docker安装mysql 打开[镜像][Link 1] hub.docker.com 搜索mysql

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3oxMzYxNTQ4MDczNw_size_16_color_FFFFFF_t_70][]

选择要下载的镜像 我这选的是5.7

docker pull mysql:5.7.28

![20200129150006193.png][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3oxMzYxNTQ4MDczNw_size_16_color_FFFFFF_t_70 1][]

在页面搜索 Environment Variables  搜可以看到关于参数的说明

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3oxMzYxNTQ4MDczNw_size_16_color_FFFFFF_t_70 2][]

启动 --name 给容器起个名字 -p端口映射  -v目录映射 宿主机的目录映射到容器的目录  -e Mysql\_ROOT\_PASSWORD 设置密码

设置的参数按优先级 没设置的参数采用默认值，

mkdir -p /www/mysql/data   这是存放mysql数据库的文件夹

docker run --name mysql5.7 -p 3307:3306 \
     -v /www/mysql/data:/var/lib/mysql \
     -v /www/mysql/conf:/etc/mysql/conf.d \
     -v /www/mysql/logs:/logs -e MYSQL_ROOT_PASSWORD=123456  mysql:5.7.28

就启动了

![20200129215620845.png][]

查看运行的容器

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3oxMzYxNTQ4MDczNw_size_16_color_FFFFFF_t_70 3][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3oxMzYxNTQ4MDczNw_size_16_color_FFFFFF_t_70 4][]

然后就可以创建数据了。

停止docker  dicker stop  容器id

![20200129204600120.png][]

删除运行过的容器 docker rm $(docker ps -qa)

![20200129204703458.png][]

\-------------------------------------------

docker inspect mysql 命令发现环境变量

\-------------------------------------------------------------

centos 直接yum install docker -y 安装的 docker  拉取镜像docker pull docker.io/mysql （这个版本的是8.0的）有几次没启动了但是连接不上数据库报  从启了了一下虚拟就就好了

### Can't connect to local MySQL server through    socket '/var/lib/mysql/mysql.sock' 错误 ###

![20200129201525740.png][]

docker run -it -p3308:3308 -e MYSQL_ROOT_PASSWORD=123456 -v /www/mysql/data:/var/lib/mysql docker.io/mysql

![20200129201409504.png][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3oxMzYxNTQ4MDczNw_size_16_color_FFFFFF_t_70 5][]

[Link 1]: http://hub.docker.com
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3oxMzYxNTQ4MDczNw_size_16_color_FFFFFF_t_70]: https://img-blog.csdnimg.cn/2020012914555923.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3oxMzYxNTQ4MDczNw==,size_16,color_FFFFFF,t_70
[20200129150006193.png]: https://img-blog.csdnimg.cn/20200129150006193.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3oxMzYxNTQ4MDczNw_size_16_color_FFFFFF_t_70 1]: https://img-blog.csdnimg.cn/202001291457074.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3oxMzYxNTQ4MDczNw==,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3oxMzYxNTQ4MDczNw_size_16_color_FFFFFF_t_70 2]: https://img-blog.csdnimg.cn/20200129152729742.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3oxMzYxNTQ4MDczNw==,size_16,color_FFFFFF,t_70
[20200129215620845.png]: https://img-blog.csdnimg.cn/20200129215620845.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3oxMzYxNTQ4MDczNw_size_16_color_FFFFFF_t_70 3]: https://img-blog.csdnimg.cn/20200129173859715.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3oxMzYxNTQ4MDczNw==,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3oxMzYxNTQ4MDczNw_size_16_color_FFFFFF_t_70 4]: https://img-blog.csdnimg.cn/20200129173805345.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3oxMzYxNTQ4MDczNw==,size_16,color_FFFFFF,t_70
[20200129204600120.png]: https://img-blog.csdnimg.cn/20200129204600120.png
[20200129204703458.png]: https://img-blog.csdnimg.cn/20200129204703458.png
[20200129201525740.png]: https://img-blog.csdnimg.cn/20200129201525740.png
[20200129201409504.png]: https://img-blog.csdnimg.cn/20200129201409504.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3oxMzYxNTQ4MDczNw_size_16_color_FFFFFF_t_70 5]: https://img-blog.csdnimg.cn/20200129201055750.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3oxMzYxNTQ4MDczNw==,size_16,color_FFFFFF,t_70