com.mysql.cj.exceptions.InvalidConnectionAttributeException: The server time zone value 'ÖÐ¹ú±ê×¼Ê±¼...

最新推荐文章于 2022-10-01 23:18:27 发布

alx69793

最新推荐文章于 2022-10-01 23:18:27 发布

阅读量282

点赞数

文章标签：数据库 java

原文链接：http://www.cnblogs.com/Godric/p/10367021.html

版权

Spring boot使用MyBatis，mysql配置运行时报错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 propert，其实这个不是mybatis的问题，而是mysql配置url中时区的设置，serverTimezone=UTC

spring.datasource.driver-class-name=com.mysql.jdbc.Driver
spring.datasource.url=jdbc:mysql://localhost:3306/chapter4?useUnicode=true&serverTimezone=UTC
spring.datasource.username=root
spring.datasource.password=123456
spring.datasource.max-idle=10
spring.datasource.max-wait=10000
spring.datasource.min-idle=5
spring.datasource.initial-size=5

转载于:https://www.cnblogs.com/Godric/p/10367021.html