用的是mysql,idea是社区版的。

来源:6-1 关于红包收发之操作数据库(上)

炫德基

2019-08-09

Caused by: com.mysql.cj.exceptions.InvalidConnectionAttributeException: The server time zone value ‘Öйú±ê׼ʱ¼ä’ is unrecognized or represents more than one time zone. You must configure either the server or JDBC driver (via the serverTimezone configuration property) to use a more specifc time zone value if you want to utilize time zone support.

配置文件
spring:
datasource:
driver-class-name: com.mysql.cj.jdbc.Driver
url: jdbc:mysql://127.0.0.1:3306/TextSpring
useUnicode: true
useJDBCCompliantTimezoneShift: true
useLegacyDatetimeCode: false
serverTimezone: UTC
username: root
password:
jpa:
hibernate:
ddl-auto: create
show-sql: true

写回答

2回答

weixin_慕虎2099244

2019-08-11

mysql的时区配置有问题

在mysql里运行set global time_zone='+8:00';即可

1
0

慕函数6483789

2019-09-01

时区问题,mysql默认是零时区,根据你的时区修改


0
0

2小时快速上手Spring Boot

一切为了效率!两个小时学习SpringBoot,为你省时省力Get干货

11582 学习 · 249 问题

查看课程