6 运维-ubuntu16.04.6xenial-基础环境搭建-docker集成mysql

小鱼儿 2024-04-17 05:30 14阅读 0赞

### 文章目录 ###

*  1 安装
 *  2 验证
 *   *  2.1 浏览器验证
     *  2.2 连接工具验证

# 1 安装 #

1 创建安装目录

mkdir -p /usr/local/docker/mysql

2 进入安装目录

cd /usr/local/docker/mysql

3 编辑compose文件

version: '3.1'
    services:
      db:
        restart: always
        image: mysql:5.7
        container_name: db_mysql
        environment:
          MYSQL_ROOT_PASSWORD: 123456
        ports:
         - 3306:3306
        volumes:  
          - /usr/local/docker/mysql/conf:/etc/mysql 
          - /usr/local/docker/mysql/logs:/var/log/mysql 
          - /usr/local/docker/mysql/data:/var/lib/mysql 
    
      adminer:
        image: adminer
        restart: always
        ports:
          - 84:8080

4 启动容器

docker-compose up -d

# 2 验证 #

## 2.1 浏览器验证 ##

浏览器中输入`http://192.168.30.143:84`，输入登录名root密码123456，如下图所示  
![登录页][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTU0NDQ2NQ_size_16_color_FFFFFF_t_70]  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTU0NDQ2NQ_size_16_color_FFFFFF_t_70 1]

## 2.2 连接工具验证 ##

1 采用sqlyog连接，输入ip地址、用户名、密码，测试连接，效果图如下  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTU0NDQ2NQ_size_16_color_FFFFFF_t_70 2]  
2 测试连接成功，进行连接，初始化的数据库效果图如下  
![在这里插入图片描述][20190822171718253.png]

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTU0NDQ2NQ_size_16_color_FFFFFF_t_70]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/11/cc76b65729de41b09508a8984993cce5.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTU0NDQ2NQ_size_16_color_FFFFFF_t_70 1]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/11/3082b0464cd945ce8ecdc66ee755daea.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTU0NDQ2NQ_size_16_color_FFFFFF_t_70 2]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/11/ff213d4d27c548af88a771b9e424a1a7.png
[20190822171718253.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/11/68e21b47e41445d581dfdcc2620eb715.png