1、docker-compose.yml

三个文件夹映射

      - /home/mysql/log:/var/log/mysql 
      - /home/mysql/data:/var/lib/mysql 
      - /home/mysql/conf.d:/etc/mysql/conf.d 

version: '3'
services:
  mysql: 
    image: mysql:8.0.18 
    container_name: mysql8 
    environment:
      - MYSQL_ROOT_PASSWORD=xxxxxxxxx
    volumes:
      - /home/mysql/log:/var/log/mysql 
      - /home/mysql/data:/var/lib/mysql 
      - /home/mysql/conf.d:/etc/mysql/conf.d 
      - /etc/localtime:/etc/localtime:ro
    ports:
      - 3306:3306 
    restart: always
    networks:
      - mysql
networks:
  mysql:
    driver: bridge

2、my.cnf  在 /home/mysql/conf.d目录下

###### [client]配置模块 ######
[client]
default-character-set=utf8mb4
socket=/var/lib/mysql/mysql.sock

###### [mysql]配置模块 ######
[mysql]
# 设置MySQL客户端默认字符集
default-character-set=utf8mb4
socket=/var/lib/mysql/mysql.sock

###### [mysqld]配置模块 ######
[mysqld]
port=3306
user=mysql
# 设置sql模式 sql_mode模式引起的分组查询出现*this is incompatible with sql_mode=only_full_group_by，这里最好剔除ONLY_FULL_GROUP_BY
sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
server-id = 1

# MySQL8 的密码认证插件 如果不设置低版本navicat无法连接
default_authentication_plugin=mysql_native_password

# 禁用符号链接以防止各种安全风险
symbolic-links=0

# 允许最大连接数
max_connections=2000

# 服务端使用的字符集默认为8比特编码的latin1字符集
character-set-server=utf8mb4

# 创建新表时将使用的默认存储引擎
default-storage-engine=INNODB

# 0: 表名将按指定方式存储，并且比较区分大小写;
# 1: 表名以小写形式存储在磁盘上，比较不区分大小写；
lower_case_table_names=0

max_allowed_packet=16M 

# 设置时区
default-time_zone='+8:00'