mysql

mysql57

目录结构

/usr/local/docker/mysql57# tree
.
└── docker-compose.yml

docker-compose.yml

version: '3.1'
services:
    mysql:
      image: 'mysql:5.7.22'
      restart: always
      container_name: mysql
      ports:
        - '3307:3306'
      environment:
        TZ: 'Asia/Shanghai'
        MYSQL_ROOT_PASSWORD: 123456
      command:
        --character-set-server=utf8mb4
        --collation-server=utf8mb4_general_ci
        --explicit_defaults_for_timestamp=true
        --lower_case_table_names=1
        --max_allowed_packet=128M
        --sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION,NO_ZERO_DATE,NO_ZERO_IN_DATE,ERROR_FOR_DIVISION_BY_ZERO"
      volumes:
        # 在左边宿主机中起了个名字叫 mysql-data 的文件夹，就需要在宿主机定义下 mysql-data
        - mysql-data:/var/lib/mysql
volumes:
  # 定义 mysql-data ：存放位置(不写一般默认在 /var/lib/docker/volumes)
  mysql-data: