创建目录

cd ~ && mkdir mysql && cd $_

docker-compose 内容

version: '3'
services:
  mysql:
    image: mysql:8.0.27
    restart: always
    container_name: mysql
    environment:
      MYSQL_ROOT_PASSWORD: 123456
      TZ: Asia/Shanghai
    ports:
      - 3306:3306
    volumes:
      -  ./mysql-files:/var/lib/mysql-files
      - ./data:/var/lib/mysql
      - ./my.cnf:/etc/mysql/my.cnf
    command:
      --max_connections=1000
      --character-set-server=utf8mb4
      --collation-server=utf8mb4_general_ci
      --default-authentication-plugin=mysql_native_password

配置文件

[mysqld]
user=mysql
default-storage-engine=INNODB
character-set-server=utf8
[client]
default-character-set=utf8
[mysql]
default-character-set=utf8
[mysqld]
secure-file-priv=/var/lib/mysql-files

启动脚本工具链