使用docker-compose安装mysql

# docker-compose.yaml

services:
  mysql:
    restart: always
    image: mysql
    ports:
      - 3306:3306
    command:
      --character-set-server=utf8mb4
      --collation-server=utf8mb4_general_ci
    environment:
      MYSQL_ROOT_PASSWORD: root
    volumes:
      - ./log:/var/log/mysql
      - ./data:/var/lib/mysql
      - ./cnf:/etc/mysql/conf.d
      - /etc/localtime:/etc/localtime

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16

# 配置文件

./cnf/custom.cnf

[mysqld]
sql_mode='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION'

1
2

sql_mode解决group by的问题

# 启动命令

docker-compose up -d

# 关闭

docker-compose down

#MYSQL,DOCKER

上次更新: 2024/09/30, 01:34:11

← Docker环境下安装redis哨兵模式