使用SpringBoot框架时连接数据库出现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