docker-compose mysql配置

mysql:
    image: mysql:5.7.44
    container_name: mysql-oc-dev
    restart: always
    ports:
      - 33307:3306
    environment:
      #数据库root密码的密码root
      - MYSQL_ROOT_PASSWORD=password
      #创建的库
      - MYSQL_DATABASE=oc
      #允许多IP连接数据库
      - MYSQL_ROOT_HOST=%
    #挂载数据卷
    volumes:
      - /etc/localtime:/etc/localtime:ro
      - ./mysql/data:/var/lib/mysql
      - ./mysql/logs:/var/log/mysql
    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
      --sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
      --max_allowed_packet=5120M
      --max_connections=10000
      --innodb_buffer_pool_size=2048M
      --plugin-load-add=connection_control.so
      --connection-control-failed-connections-threshold=5
      --connection-control-min-connection-delay=300000
      --wait_timeout=28800
      --interactive_timeout=28800
      --slow_query_log=1
      --slow_query_log_file=/var/log/mysql/mysql-slow.log
      --long_query_time=5
      --log-error=/var/log/mysql/mysql-error.log