创建目录
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
启动脚本工具链