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

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

后台错误信息

                          Loading class`com.mysql.jdbc.Driver'. This is deprecated. The new driver class is`com.mysql.cj.jdbc.Driver'. The driver is automatically registered via the SPIand manual loading of the driver class is generally unnecessary.

Sat Mar31 14:02:27 CST 2018 WARN: Establishing SSL connection without server'sidentity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+and 5.7.6+ requirements SSL connection must be established by default ifexplicit option isn't set. For compliance with existing applications not usingSSL the verifyServerCertificate property is set to 'false'. You need either toexplicitly disable SSL by setting useSSL=false, or set useSSL=true and providetruststore for server certificate verification.

2018-03-3114:02:27.357 ERROR 4844 --- [nio-8080-exec-3]o.a.tomcat.jdbc.pool.ConnectionPool     : Unable to create initial connections of pool.



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