docker-compose-mysql.yml

version: "3"
services:
  mysql:
    restart: always
    hostname: mysql
    image: mysql:8.0
    container_name: mysql-8.0
    privileged: true
    command:
      --default-authentication-plugin=mysql_native_password
      --character-set-server=utf8mb4
      --collation-server=utf8mb4_general_ci
      --explicit_defaults_for_timestamp=true
      --lower_case_table_names=1
      --max_allowed_packet=128M
    environment:
      - TZ=Asia/Shanghai
      - MYSQL_ROOT_PASSWORD=yIJEMd47PNSOIc0V
    volumes:
      - ./data/mysql/db:/var/lib/mysql
    ports:
      - "3306:3306"