docker-compose启动mysql 8

1. mysql目录

• 创建mysql目录
• 进入该目录，创建docker-compose.yml和my.cnf文件，内容如下：

2. docker-compose.yml文件

command 中的参数将在"2. 解决的问题中说明"

version: '3.1'
services:
 mysql_server:
  image: mysql:8
  restart: always
  environment:
    MYSQL_ROOT_PASSWORD: "Bxxxxxx"
    MYSQL_USER: 'liubei'
    MYSQL_PASSWORD: 'liubei@221'
    MYSQL_DATABASE:  'liubeidb'
  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
    --max_allowed_packet=128M;
  ports:
    - 3306:3306
  volumes:
    - ./data:/var/lib/mysql
    - ./my.cnf:/etc/mysql/my.cnf

3. my.cnf 文件

[mysqld]
pid-file        = /var/run/mysqld/mysqld.pid
socket          = /var/run/mysqld/mysqld.sock
datadir         = /var/lib/mysql
secure-file-priv= NULL
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0

character_set_server=utf8
collation-server=utf8_general_ci

max_connections=1000

[client]
default-character-set=utf8
# Custom config should go here
!includedir /etc/mysql/conf.d/

---