my.cnf
[mysqld]
port=3306
server-id=1
log-bin=mysql-bin
binlog_format=row
binlog-do-db=shopping_mall_main
[mysql]
# 设置mysql客户端默认字符集
default-character-set=utf8mb4
[client]
# 设置mysql客户端连接服务端时默认使用的端口
port=3306
default-character-set=utf8mb4
docker-compose.yml
version: '3'
services:
db:
image: mysql:latest
restart: always
environment:
- MYSQL_DATABASE=shopping_mall_main
- MYSQL_ROOT_PASSWORD=chenhaifeng
ports:
- "3306:3306"
volumes:
- ./datas/mysql/:/var/lib/mysql
- ./conf/mysql/my.cnf:/etc/mysql/my.cnf
- ./datas/mysql-files:/var/lib/mysql-files/
depends_on:
- redis
container_name: db
redis:
restart: always
image: redis:latest
volumes:
- ./datas/redis/:/data
ports:
- "6379:6379"
container_name: redis