连接mysql数据库报错java.sql.SQLException: The server time zone value '�й���׼ʱ��' is unrecognized...解决方法

　　今天连接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.

	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:545)

	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:513)

	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:505)

	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:479)

	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:489)

	at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:69)

	at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:1606)

	at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:633)

	at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:347)

	at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:219)

	at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1461)

	at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1525)

	at com.alibaba.druid.pool.DruidDataSource$CreateConnectionThread.run(DruidDataSource.java:2100)

Caused by: com.mysql.cj.core.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 property) to use a more specifc time zone value if you want to utilize time zone support.

	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)

	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)

	at java.lang.reflect.Constructor.newInstance(Constructor.java:423)

	at com.mysql.cj.core.exceptions.ExceptionFactory.createException(ExceptionFactory.java:54)

	at com.mysql.cj.core.exceptions.ExceptionFactory.createException(ExceptionFactory.java:73)

	at com.mysql.cj.jdbc.util.TimeUtil.getCanonicalTimezone(TimeUtil.java:118)

	at com.mysql.cj.mysqla.MysqlaSession.configureTimezone(MysqlaSession.java:293)

	at com.mysql.cj.jdbc.ConnectionImpl.initializePropsFromServer(ConnectionImpl.java:2399)

	at com.mysql.cj.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:1739)

	at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:1596)

	... 6 common frames omitted

配置文件中：

######数据库链接配置########

spring.datasource.url=jdbc\:mysql\://127.0.0.1\:3306/aa

spring.datasource.username=root

spring.datasource.password=123456

spring.datasource.driver-class-name=com.mysql.jdbc.Driver

spring.datasource.type=com.alibaba.druid.pool.DruidDataSource

解决方法：

修改配置文件内容：

######数据库链接配置########

spring.datasource.url=jdbc\:mysql\://127.0.0.1\:3306/aa?useUnicode=true&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&serverTimezone=UTC

spring.datasource.username=root

spring.datasource.password=123456

spring.datasource.driver-class-name=com.mysql.jdbc.Driver

spring.datasource.type=com.alibaba.druid.pool.DruidDataSource

在配置 spring.datasource.url 的时候加上后面的配置就可以了

版权声明：本文为博主原创文章，未经博主允许不得转载。

http://www.cnblogs.com/tangyin/p/8864890.html

连接mysql数据库报错java.sql.SQLException: The server time zone value '�й���׼ʱ��' is unrecognized...解决方法的相关教程结束。