docker-compose安装方式参考: https://blog.csdn.net/lyzklkl/article/details/120335277?spm=1001.2014.3001.5501

mysql8 的 docker-compose.yaml :

version: '3.3'
services:
  mysql-app:
    image: 'mysql:8.0'
    container_name: 'mysql'
    restart: always
    ports:
      - '3306:3306'
    environment:
      MYSQL_ROOT_PASSWORD: root  # root用户的密码
      MYSQL_ROOT_HOST: '%'       # 访问权限
      MYSQL_USER: test           # 创建新用户
      MYSQL_PASSWORD: test       # 新用户的密码
    volumes:
      - '/etc/localtime:/etc/localtime:ro'  #同步宿主机日期时间到容器
      - '/opt/app/mysql/data:/var/lib/mysql'
      - '/opt/app/mysql/conf:/etc/mysql/conf.d'
      - '/opt/app/mysql/logs:/logs'
    command:
      # default-authentication-plugin=mysql_native_password   mysql5为mysql_native_password, 支持较好, mysql8为默认为caching_sha2_password, 部分旧软件不支持;
      # character-set-server=utf8mb4                          默认创建新数据的新建字符集
      # collation-server=utf8mb4_general_ci                   默认创建新数据的新建排序规则
      # default-time-zone='+8:00'                             选择正8区
      # max_connections=1000                                  设置最大连接数
      # innodb_lock_wait_timeout=500                          innodb的dml操作的行级锁的等待时间
      --default-authentication-plugin=mysql_native_password
      --character-set-server=utf8mb4
      --collation-server=utf8mb4_general_ci
      --default-time-zone='+8:00'
      --max_connections=1000
      --innodb_lock_wait_timeout=500