docker安装mysql，并实现远程连接

怼烎@ 2023-10-06 12:07 12阅读 0赞

版本更新比较快，建议按照官网说明安装，以下两个按照文档地址都可以成功安装

*  MySQL 官网：
    
     *  镜像 mysql:mysql-server
     *  安装地址 [https://dev.mysql.com/doc/refman/8.0/en/docker-mysql-getting-started.html][https_dev.mysql.com_doc_refman_8.0_en_docker-mysql-getting-started.html]
 *  Docker 官网：
    
     *  镜像 mysql
     *  安装地址：[https://hub.docker.com/\_/mysql][https_hub.docker.com_mysql]

下面以 Docker 的镜像 mysql 为例

##### 1、查询想要安装的mysql版本 #####

链接: [https://hub.docker.com/][https_hub.docker.com].  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQxNTM4MDk3_size_16_color_FFFFFF_t_70]

##### 2、根据镜像描述选择合适版本 #####

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQxNTM4MDk3_size_16_color_FFFFFF_t_70 1]

##### 3、拉去mysql镜像（我选的8.0） #####

//拉去 mysql:8.0 镜像
    docker pull mysql:8.0
    //查看所有镜像
    docker images

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQxNTM4MDk3_size_16_color_FFFFFF_t_70 2]

##### 4、创建mysql容器 #####

建议将配置文件挂载出来（`但是 docker 安装的 mysql 默认目录 /etc/mysql/conf.d 为空`），不用预先下载

在 /home/mysql/conf 目录下，新增 my.cnf 文件添加如下内容

# Copyright (c) 2017, Oracle and/or its affiliates. All rights reserved.
    #
    # This program is free software; you can redistribute it and/or modify
    # it under the terms of the GNU General Public License as published by
    # the Free Software Foundation; version 2 of the License.
    #
    # This program is distributed in the hope that it will be useful,
    # but WITHOUT ANY WARRANTY; without even the implied warranty of
    # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
    # GNU General Public License for more details.
    #
    # You should have received a copy of the GNU General Public License
    # along with this program; if not, write to the Free Software
    # Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA  02110-1301 USA
    
    #
    # The MySQL  Server configuration file.
    #
    # For explanations see
    # http://dev.mysql.com/doc/mysql/en/server-system-variables.html
    
    [mysqld]
    pid-file        = /var/run/mysqld/mysqld.pid
    socket          = /var/run/mysqld/mysqld.sock
    datadir         = /var/lib/mysql
    secure-file-priv= NULL
    default-time-zone = '+8:00'
    
    #最大链接数
    max_connections=1024
    
    #是否对sql语句大小写敏感，1表示不敏感
    lower_case_table_names=1
    log_bin_trust_function_creators=1
    #启用log-bin
    log-bin=mysql-bin
    
    #设置日志格式
    binlog_format=mixed
    
    #设置binlog清理时间
    expire_logs_days=7
    
    # 数据表默认时区
    default-time-zone='+08:00'
    
    # Custom config should go here
    !includedir /etc/mysql/conf.d/

运行命令挂载配置文件和数据即可

docker run --name mysql -d -p 3307:3306 -e MYSQL_ROOT_PASSWORD=123456 -v /home/mysql/conf:/etc/mysql/conf.d -v /home/mysql/data:/var/lib/mysql mysql:8.0

**命令说明**  
**-p 3307:3306**：将宿主机的3307端口映射到容器的3306端口（默认3306:3306）

**-v /home/mysql/conf:/etc/mysql/conf.d -v /home/mysql/data:/var/lib/mysql**：将配置文件和数据挂载出来，注意不同版本配置文件数据目录可能不同，详细信息可在官网查看

**-e MYSQL\_ROOT\_PASSWORD=123456**：初始化root用户的密码  
**-d:** 后台运行容器，并返回容器ID

**mysql:8.0:** 你的容器id或者名字

**–name mysql8.0：** 为容器起别名，如果不设置，系统会自动生成一个名字  
![在这里插入图片描述][2020063017244352.png]

##### 5、查看所有的容器 #####

![在这里插入图片描述][20200630172517846.png]  
启动mysql8.0容器  
如果你的容器是退出状态，可以使用如下命令开启，docker8.0为你的容器id或名字

docker start docker8.0

##### 6 、进入容器 #####

//退出容器，容器不会关闭
    docker exec -it docker8.0 /bin/bash  或 docker exec -it docker8.0 bash
    //退出容器容器关闭
    docker attch -it docker8.0 /bin/bash  或 docker attch -it docker8.0 bash

\-t: 在新容器内指定一个伪终端或终端。

\-i: 允许你对容器内的标准输入 (STDIN) 进行交互。  
可以看见创建容器时设置的挂载目录  
![在这里插入图片描述][20200630173745298.png]  
![在这里插入图片描述][20200630174105402.png]

##### 7、 连接mysql mysql -u root -p #####

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQxNTM4MDk3_size_16_color_FFFFFF_t_70 3]

##### 8、 开启远程连接 #####

select host,user,plugin from mysql.user; //如下可以看到默认支持远程连接
    
    # 如果不支持使用如下语句修改(mysql/mysql-server 镜像默认没有开启远程连接)
    # update mysql.user set host ='%' where user='root';

![在这里插入图片描述][20200630212506134.png]  
有的远程连接可能是下面情况  
![在这里插入图片描述][20200630212653441.png]  
参考我的另一篇博客可以完美解决  
链接: [https://blog.csdn.net/qq\_41538097/article/details/106905416][https_blog.csdn.net_qq_41538097_article_details_106905416].

[https_dev.mysql.com_doc_refman_8.0_en_docker-mysql-getting-started.html]: https://dev.mysql.com/doc/refman/8.0/en/docker-mysql-getting-started.html
[https_hub.docker.com_mysql]: https://hub.docker.com/_/mysql
[https_hub.docker.com]: https://hub.docker.com/
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQxNTM4MDk3_size_16_color_FFFFFF_t_70]: https://img-blog.csdnimg.cn/2020063016350286.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQxNTM4MDk3,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQxNTM4MDk3_size_16_color_FFFFFF_t_70 1]: https://img-blog.csdnimg.cn/20200630163534815.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQxNTM4MDk3,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQxNTM4MDk3_size_16_color_FFFFFF_t_70 2]: https://img-blog.csdnimg.cn/20200630163938356.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQxNTM4MDk3,size_16,color_FFFFFF,t_70
[2020063017244352.png]: https://img-blog.csdnimg.cn/2020063017244352.png
[20200630172517846.png]: https://img-blog.csdnimg.cn/20200630172517846.png
[20200630173745298.png]: https://img-blog.csdnimg.cn/20200630173745298.png
[20200630174105402.png]: https://img-blog.csdnimg.cn/20200630174105402.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQxNTM4MDk3_size_16_color_FFFFFF_t_70 3]: https://img-blog.csdnimg.cn/20200630212146827.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQxNTM4MDk3,size_16,color_FFFFFF,t_70
[20200630212506134.png]: https://img-blog.csdnimg.cn/20200630212506134.png
[20200630212653441.png]: https://img-blog.csdnimg.cn/20200630212653441.png
[https_blog.csdn.net_qq_41538097_article_details_106905416]: https://blog.csdn.net/qq_41538097/article/details/106905416