docker-compose #

example 1 #

yml
version: "3.7"
services:
  mysql:
    image: mysql:8.0
    restart: on-failure
    command: |
      --default-authentication-plugin=mysql_native_password
      --character-set-server=utf8mb4
      --collation-server=utf8mb4_general_ci
      --max-allowed-packet=104800000
    volumes:
      - /etc/localtime:/etc/localtime:ro
      - mysql_data:/var/lib/mysql
    ports:
      - 3306:3306
    env_file:
      - ./mysql.env
    environment:
      - TZ=Asia/Shanghai
      - MYSQL_ROOT_PASSWORD=123456
volumes:
  mysql_data:

example 2 #

yml
# 取消其他严格设置，只保留 STRICT_TRANS_TABLES，详情请查询 sql-mode 参数
      --sql-mode=STRICT_TRANS_TABLES