docker-compose 安装 mysql8

目录

[root@meta mysql]# tree -L 2
.
├── conf
│   └── my.cnf
├── data
├── log
├── mysql-files
└── mysql.yml

docker-compose 文件

version: '3'
services:
  db:
    image: mysql:8.0
    container_name: mysql
    restart: always
    privileged: true
    user: root
    command:
      --default-authentication-plugin=mysql_native_password
      --character-set-server=utf8mb4
      --collation-server=utf8mb4_general_ci
      --explicit_defaults_for_timestamp=true
    environment: 
      MYSQL_ROOT_PASSWORD: admin
    ports:
      - 3306:3306
    volumes: 
      - ./data:/var/lib/mysql:rw
      - ./conf/my.cnf:/etc/mysql/my.cnf:rw
      - ./log:/var/log/mysql:rw
      - ./mysql-files:/var/lib/mysql-files:rw

mysql8 配置文件（ my.cnf ）

[mysqld]
pid-file        = /var/run/mysqld/mysqld.pid
socket          = /var/run/mysqld/mysqld.sock
datadir         = /var/lib/mysql
secure_file_priv=/var/lib/mysql-files

character-set-server=utf8
default_authentication_plugin=mysql_native_password
expire_logs_days=7
sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION
max_connections=1000

[client]
default-character-set=utf8

[mysql]
default-character-set=utf8