天天看点

java.sql.SQLException: The server time zone value '�й���׼ʱ��' is unrecognized..

mysql5.6.16使用jdbc连接时报错:

具体报错信息:

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里设置一下时区就行了

原:

spring.datasource.url=jdbc:mysql://localhost:3306/demo

改:

spring.datasource.url=jdbc:mysql://localhost:3306/demo?

useUnicode=true&characterEncoding=UTF-8&serverTimezone=Asia/Shanghai

继续阅读