指导:https://zhuanlan.zhihu.com/p/384330120
1.创建基本文件夹
mkdir -p /apps/mysql/{mydir,datadir,conf,source}
2.编写docker-compose.yml
version: '3'
services:
mysql:
restart: always
image: mysql:5.7.18
container_name: mysql-lable
volumes:
- ./mysql/mydir:/mydir
- ./mysql/datadir:/var/lib/mysql
- ./mysql/conf/my.cnf:/etc/my.cnf
- ./mysql/source:/docker-entrypoint-initdb.d
environment:
- "MYSQL_ROOT_PASSWORD=123"
- "TZ=Asia/Shanghai"
ports:
- 3306:3306
3.my.cnf
/apps/mysql/conf/my.cnf
[mysqld]
user=mysql
default-storage-engine=INNODB
character-set-server=utf8
character-set-client-handshake=FALSE
collation-server=utf8_unicode_ci
init_connect='SET NAMES utf8'
[client]
default-character-set=utf8
[mysql]
default-character-set=utf8
4.运行
docker-compose up -d