docker-compose mysql
[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
my.cnf文件
docker-compose文件
version: '3' services: mysql: restart: always image: mysql:5.7.16 container_name: my_mysql volumes: - ./mysql/data:/var/lib/mysql - ./mysql/conf.d:/etc/mysql/conf.d environment: - "MYSQL_ROOT_PASSWORD=root123" - "MYSQL_DATABASE=db_beego_test" - "TZ=Asia/Shanghai" ports: - 3306:3306
执行 docker-compose up -d后 到conf.d目录下创建my.cnf文件 并配置mysql信息