【环境搭建】linux docker-compose安装mysql5.7

建议改一下配置，安装mysql8.0

新建目录

mkdir -p /data/docker/mysql/data
mkdir -p /data/docker/mysql/logs
mkdir -p /data/docker/mysql/conf

给权限

chmod -R 777 /data/docker/mysql

到目录

cd /data/docker/mysql

新建docker-compose.yml文件

vi docker-compose.yml

复制配置文件内容，粘贴到docker-comose.yml中

version: '3.3'
 
services:
 
  mysql-db:
    # 指定容器的名称
    container_name: mysql     
    # 指定镜像和版本
    image: mysql:5.7                   
    ports:
      - "3306:3306"
    restart: always
    # 容器日志大小配置
    logging:
      driver: 'json-file'
      options:
        max-size: '1g'
    environment:
      # 配置root密码
      MYSQL_ROOT_PASSWORD: root
      #时区
      TZ: Asia/Shanghai
    volumes:
      # 挂载数据目录
      - "/data/docker/mysql/data:/var/lib/mysql" 
      # 挂载配置文件目录
      - "/data/docker/mysql/config:/etc/mysql/conf.d"  
      - "/data/docker/mysql/logs:/var/log/mysql"     

修改配置

cd /usr/local/mysql/conf
vim my.cnf

[client]
default_character_set=utf8
[mysqld]
collation_server=utf8_general_ci
character_set_server=utf8

启动容器

docker-compose up -d