java.sql.SQLException: The server time zone value ‘�й���׼ʱ��‘ is unrecognized or represents more tha

maven +springboot + mybatis 项目 连接数据库报错

测试数据库连接报错

后台报错信息如下:↓↓↓↓

java.sql.SQLException:The server time zone value ‘�й���׼ʱ��’ is unrecognized or represents more than onetime zone. You must configure either the server or JDBC driver (via theserverTimezone configuration property) to use a more specifc time zone value ifyou want to utilize time zone support.

Causedby: com.mysql.cj.core.exceptions.InvalidConnectionAttributeException: Theserver time zone value ‘�й���׼ʱ��’ is unrecognized or representsmore than one time zone. You must configure either the server or JDBC driver(via the serverTimezone configuration property) to use a more specifc time zonevalue if you want to utilize time zone support.

2018-03-3114:02:27.367 ERROR 4844 — [nio-8080-exec-3]o.a.c.c.C.[.[.[/].[dispatcherServlet] : Servlet.service() for servlet [dispatcherServlet] in context with path[] threw exception [Request processing failed; nested exception isorg.mybatis.spring.MyBatisSystemException: nested exception isorg.apache.ibatis.exceptions.PersistenceException:

Errorquerying database. Cause:org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBCConnection; nested exception is java.sql.SQLException: The server time zonevalue ‘�й���׼ʱ��’ is unrecognized or representsmore than one time zone. You must configure either the server or JDBC driver(via the serverTimezone configuration property) to use a more specifc time zonevalue if you want to utilize time zone support.

Theerror may exist in com/fanzs/secondskill/dao/UserDao.java (best guess)

Theerror may involve com.fanzs.secondskill.dao.UserDao.getById

Theerror occurred while executing a query

###Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not getJDBC Connection; nested exception is java.sql.SQLException: The server timezone value ‘�й���׼ʱ��’ is unrecognized or representsmore than one time zone. You must configure either the server or JDBC driver(via the serverTimezone configuration property) to use a more specifc time zonevalue if you want to utilize time zone support.] with root cause

com.mysql.cj.core.exceptions.InvalidConnectionAttributeException:The server time zone value ‘�й���׼ʱ��’ is unrecognized or represents more than onetime zone. You must configure either the server or JDBC driver (via theserverTimezone configuration property) to use a more specifc time zone value ifyou want to utilize time zone support.

解决办法

              修改配置文件 application.properties

错误的

spring.datasource.url=jdbc:mysql://localhost:3306/secondskill?useUnicode=true&characterEncoding=UTF-8
修改为↓↓↓↓
spring.datasource.url=jdbc:mysql://localhost:3306/secondskill?useUnicode=true&characterEncoding=UTF-8&serverTimezone=Asia/Shanghai