docker用yml配置mysql_Docker 下安装 MySQL时，docker-compose.yml 的写法

MySQL5

version: '3.1'

services:

mysql:

restart: always

image: mysql:5.7.22

container_name: mysql

ports:

- 3306:3306

environment:

TZ: Asia/Shanghai

MYSQL_ROOT_PASSWORD: 123456

command:

--character-set-server=utf8mb4

--collation-server=utf8mb4_general_ci

--explicit_defaults_for_timestamp=true

--lower_case_table_names=1

--max_allowed_packet=128M

--sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION,NO_ZERO_DATE,NO_ZERO_IN_DATE,ERROR_FOR_DIVISION_BY_ZERO"

volumes:

- mysql-data:/var/lib/mysql

volumes:

mysql-data:

MySQL8

version: '3.1'

services:

db:

image: mysql

restart: always

environment:

MYSQL_ROOT_PASSWORD: 123456

command:

--default-authentication-plugin=mysql_native_password

--character-set-server=utf8mb4

--collation-server=utf8mb4_general_ci

--explicit_defaults_for_timestamp=true

--lower_case_table_names=1

ports:

- 3306:3306

volumes:

- ./data:/var/lib/mysql

adminer:

image: adminer

restart: always

ports:

- 8080:8080

注意：

MySQL8 在连接时，要加上时区

jdbc.driverClass=com.mysql.cj.jdbc.Driver

jdbc.connectionURL=jdbc:mysql://192.168.1.25:3306/shop?useUnicode=true&characterEncoding=utf-8&useSSL=false&serverTimezone=UTC

jdbc.username=root

jdbc.password=root