MySQL时区异常
使用SpringBoot框架时连接数据库出现MySQL时区异常
异常信息
java.sql.SQLException: 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.
处理方式
配置数据库连接信息时,在url地址后添加设置时区参数(serverTimezone=Asia/Shanghai),中国是在东八区,具体配置如下:
# 数据源配置信息
spring:
datasource:
druid:
driver-class-name: com.mysql.cj.jdbc.Driver
url: jdbc:mysql://localhost:3306/test?serverTimezone=Asia/Shanghai
username: root
password: abc123