指导:https://zhuanlan.zhihu.com/p/384330120

1.创建基本文件夹

mkdir -p /apps/mysql/{mydir,datadir,conf,source}

2.编写docker-compose.yml

  1. version: '3'
  2. services:
  3. mysql:
  4. restart: always
  5. image: mysql:5.7.18
  6. container_name: mysql-lable
  7. volumes:
  8. - ./mysql/mydir:/mydir
  9. - ./mysql/datadir:/var/lib/mysql
  10. - ./mysql/conf/my.cnf:/etc/my.cnf
  11. - ./mysql/source:/docker-entrypoint-initdb.d
  12. environment:
  13. - "MYSQL_ROOT_PASSWORD=123"
  14. - "TZ=Asia/Shanghai"
  15. ports:
  16. - 3306:3306

3.my.cnf

/apps/mysql/conf/my.cnf

  1. [mysqld]
  2. user=mysql
  3. default-storage-engine=INNODB
  4. character-set-server=utf8
  5. character-set-client-handshake=FALSE
  6. collation-server=utf8_unicode_ci
  7. init_connect='SET NAMES utf8'
  8. [client]
  9. default-character-set=utf8
  10. [mysql]
  11. default-character-set=utf8

4.运行

  1. docker-compose up -d