Docker 实战系列 - MySQL环境

约定不等于承诺〃 2023-06-10 09:29 16阅读 0赞

## 前言 ##

[Git阅读风格，点击这里][Git]  
可以查看一下 Docker的环境安装

[Docker 环境安装][Docker]

## docker 方式 ##

创建目录，用于存放mysql文件

mkdir mysql
    chown -R 1000:1000 mysql

直接启动

docker run -d --network host --name my-mysql \
    -v $PWD/mysql:/var/lib/mysql \
    -e MYSQL_ROOT_PASSWORD=123456 \
    mysql:5.7.27

简单带配置项启动

docker run -d --network host --name my-mysql \
    -v $PWD/mysql.cnf:/etc/mysql/conf.d/mysql.cnf \
    -v $PWD/mysql:/var/lib/mysql \
    -e MYSQL_ROOT_PASSWORD=123456 \
    mysql:5.7.27

如果修改了 `datadir` 请使用如下配置

[mysqld]
    pid-file = /var/run/mysqld/mysqld.pid
    socket	= /var/run/mysqld/mysqld.sock
    datadir	= /var/lib/datadir
    basedir = /var/lib/mysql
    log_bin = mysql-bin
    server-id = 1111
    secure_file_priv="/"

docker run -d --network host --name my-mysql \
    -v $PWD/mysql.cnf:/etc/mysql/mysql.conf.d/mysqld.cnf \
    -v $PWD/db_backup:/data/db_backup \
    -v $PWD/mysql:/var/lib/mysql \
    -v $PWD/datadir:/var/lib/datadir \
    -e MYSQL_ROOT_PASSWORD=123456 \
    mysql:5.7.27

进入容器内

docker exec -it my-mysql bash

创建数据库

mysql -uroot -p -e"create database customer_db"

导入数据

mysql -uroot -p customer_db < bak_imooc.sql

## docker-compose 方式 ##

docker-compose.yml

version: '3'
    
    services:
    
      mysql:
        image: mysql:8.0.17
        network_mode: host
        container_name: xm-mysql
    
        volumes:
          - ./data/mysql:/var/lib/mysql
          # 如果有自己的mysql配置
          - ./mysql.cnf:/etc/mysql/conf.d/mysql.cnf
          # 如果有初始化MySQL
          - ./init.sql:/docker-entrypoint-initdb.d/init.sql
        ports:
          - "3306:3306"
        restart: always
        environment:
          MYSQL_ROOT_PASSWORD: a123456
          MYSQL_DATABASE: test_database

启动

docker-compose up -d

[Git]: https://www.7s.app/docker/docker-shi-zhan-xi-lie-mysql-huan-jing
[Docker]: https://www.7s.app/docker/docker-huan-jing-an-zhuang