博客

通过docker-compose快速搭建数据库，并且修改相关字符集为utf8mb4

vi docker-compose.yml

version: ‘2’

services:

mysql:

image: mysql:5.7.22

restart: always

container_name: mysql

volumes:

– ./mysql:/var/lib/mysql

– ./conf:/etc/mysql

– /etc/localtime:/etc/localtime

environment:

– TZ=Asia/Shanghai

– MYSQL_ROOT_PASSWORD=123456

ports:

– 13506:3306

#network_mode: ‘host’

#数据库删减版配置文件

vi ./conf/my.cnf

[mysql]

default-character-set = utf8mb4

[client]

default-character-set = utf8mb4

[mysqld]

pid-file = /var/run/mysqld/mysqld.pid

socket = /var/run/mysqld/mysqld.sock

datadir = /var/lib/mysql

symbolic-links=0

character-set-server = utf8mb4

#sql模块修改

sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

#允许最大传输文件大小

max_allowed_packet = 1G