一、创建目录

# 1、先创建 mysql8 的目录，并进入该目录
cd /usr/local/docker/mysql8
# 2、创建挂载目录
mkdir -p /usr/local/docker/mysql8/{log,data,conf,mysql-files}
# 2、创建 docker-compose.yml
vi docker-compose.yml

二、创建 docker-compose.yml

vi docker-compose.yml

docker-compose.yml

version: '3.1'
services:
  mysql:
    container_name: mysql8
    image: mysql:8.0.25
    restart: always
    ports:
      - 3306:3306
    command:
      --default-authentication-plugin=mysql_native_password
      --character-set-server=utf8mb4
      --collation-server=utf8mb4_general_ci
    environment:
      MYSQL_ROOT_PASSWORD: 123456
    volumes:
      - ./log:/var/log/mysql
      - ./data:/var/lib/mysql
      - ./conf:/etc/mysql
      - ./mysql-files:/var/lib/mysql-files

三、执行 docker-compose

# 在 mysql8 目录执行
docker-compose up -d

my.cnf 配置

# 3、创建 my.cnf
vi my.cnf

my.cnf

[mysqld]
pid-file        = /var/run/mysqld/mysqld.pid
socket            = /var/run/mysqld/mysqld.sock
datadir            = /var/lib/mysql
source-file-priv= NULL
symbolic-links=0
lower_case_table_names=1
max_connections=3000
skip-log-bin
!includedir /etc/mysql/conf.d/