springboot启动报错（java.sql.SQLException: The server time zone value ‘�й���׼ʱ��‘ is unrecognized or rep）

最新推荐文章于 2021-07-28 15:57:33 发布
最新推荐文章于 2021-07-28 15:57:33 发布
阅读量356 收藏 1
点赞数
分类专栏： springBoot启动异常
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/l13880647015/article/details/109724820
版权

Spring Boot MySQL 数据库连接 时区配置 启动失败
关键词由CSDN通过智能技术生成

一：springboot启动报错（原因是:数据库连接中未加上全球标准时间serverTimezone=UTC）

D:\localfile\jdk-8u172-windows-i586\bin\java.exe -agentlib:jdwp=transport=dt_socket,address=127.0.0.1:52210,suspend=y,server=n -XX:TieredStopAtLevel=1 -noverify -Dspring.output.ansi.enabled=always -Dcom.sun.management.jmxremote -Dspring.jmx.enabled=true -Dspring.liveBeansView.mbeanDomain -Dspring.application.admin.enabled=true -javaagent:C:\Users\Administrator\.IntelliJIdea2019.1\system\captureAgent\debugger-agent.jar -Dfile.encoding=UTF-8 -classpath "D:\localfile\jdk-8u172-windows-i586\jre\lib\charsets.jar;D:\localfile\jdk-8u172-windows-i586\jre\lib\deploy.jar;D:\localfile\jdk-8u172-windows-i586\jre\lib\ext\access-bridge-32.jar;D:\localfile\jdk-8u172-windows-i586\jre\lib\ext\access-bridge.jar;D:\localfile\jdk-8u172-windows-i586\jre\lib\ext\cldrdata.jar;D:\localfile\jdk-8u172-windows-i586\jre\lib\ext\dnsns.jar;D:\localfile\jdk-8u172-windows-i586\jre\lib\ext\jaccess.jar;D:\localfile\jdk-8u172-windows-i586\jre\lib\ext\jfxrt.jar;D:\localfile\jdk-8u172-windows-i586\jre\lib\ext\localedata.jar;D:\localfile\jdk-8u172-windows-i586\jre\lib\ext\nashorn.jar;D:\localfile\jdk-8u172-windows-i586\jre\lib\ext\sunec.jar;D:\localfile\jdk-8u172-windows-i586\jre\lib\ext\sunjce_provider.jar;D:\localfile\jdk-8u172-windows-i586\jre\lib\ext\sunmscapi.jar;D:\localfile\jdk-8u172-windows-i586\jre\lib\ext\sunpkcs11.jar;D:\localfile\jdk-8u172-windows-i586\jre\lib\ext\zipfs.jar;D:\localfile\jdk-8u172-windows-i586\jre\lib\javaws.jar;D:\localfile\jdk-8u172-windows-i586\jre\lib\jce.jar;D:\localfile\jdk-8u172-windows-i586\jre\lib\jfr.jar;D:\localfile\jdk-8u172-windows-i586\jre\lib\jfxswt.jar;D:\localfile\jdk-8u172-windows-i586\jre\lib\jsse.jar;D:\localfile\jdk-8u172-windows-i586\jre\lib\management-agent.jar;D:\localfile\jdk-8u172-windows-i586\jre\lib\plugin.jar;D:\localfile\jdk-8u172-windows-i586\jre\lib\resources.jar;D:\localfile\jdk-8u172-windows-i586\jre\lib\rt.jar;D:\ideaWork\springboot-mybatisplus\target\classes;D:\localfile\apache-maven-3.5.4\repository\org\springframework\boot\spring-boot-starter-web\2.3.5.RELEASE\spring-boot-starter-web-2.3.5.RELEASE.jar;D:\localfile\apache-maven-3.5.4\repository\org\springframework\boot\spring-boot-starter\2.3.5.RELEASE\spring-boot-starter-2.3.5.RELEASE.jar;D:\localfile\apache-maven-3.5.4\repository\org\springframework\boot\spring-boot\2.3.5.RELEASE\spring-boot-2.3.5.RELEASE.jar;D:\localfile\apache-maven-3.5.4\repository\org\springframework\boot\spring-boot-starter-logging\2.3.5.RELEASE\spring-boot-starter-logging-2.3.5.RELEASE.jar;D:\localfile\apache-maven-3.5.4\repository\ch\qos\logback\logback-classic\1.2.3\logback-classic-1.2.3.jar;D:\localfile\apache-maven-3.5.4\repository\ch\qos\logback\logback-core\1.2.3\logback-core-1.2.3.jar;D:\localfile\apache-maven-3.5.4\repository\org\apache\logging\log4j\log4j-to-slf4j\2.13.3\log4j-to-slf4j-2.13.3.jar;D:\localfile\apache-maven-3.5.4\repository\org\apache\logging\log4j\log4j-api\2.13.3\log4j-api-2.13.3.jar;D:\localfile\apache-maven-3.5.4\repository\org\slf4j\jul-to-slf4j\1.7.30\jul-to-slf4j-1.7.30.jar;D:\localfile\apache-maven-3.5.4\repository\jakarta\annotation\jakarta.annotation-api\1.3.5\jakarta.annotation-api-1.3.5.jar;D:\localfile\apache-maven-3.5.4\repository\org\yaml\snakeyaml\1.26\snakeyaml-1.26.jar;D:\localfile\apache-maven-3.5.4\repository\org\springframework\boot\spring-boot-starter-json\2.3.5.RELEASE\spring-boot-starter-json-2.3.5.RELEASE.jar;D:\localfile\apache-maven-3.5.4\repository\com\fasterxml\jackson\core\jackson-databind\2.11.3\jackson-databind-2.11.3.jar;D:\localfile\apache-maven-3.5.4\repository\com\fasterxml\jackson\core\jackson-annotations\2.11.3\jackson-annotations-2.11.3.jar;D:\localfile\apache-maven-3.5.4\repository\com\fasterxml\jackson\core\jackson-core\2.11.3\jackson-core-2.11.3.jar;D:\localfile\apache-maven-3.5.4\repository\com\fasterxml\jackson\datatype\jackson-datatype-jdk8\2.11.3\jackson-datatype-jdk8-2.11.3.jar;D:\localfile\apache-maven-3.5.4\repository\com\fasterxml\jackson\datatype\jackson-datatype-jsr310\2.11.3\jackson-datatype-jsr310-2.11.3.jar;D:\localfile\apache-maven-3.5.4\repository\com\fasterxml\jackson\module\jackson-module-parameter-names\2.11.3\jackson-module-parameter-names-2.11.3.jar;D:\localfile\apache-maven-3.5.4\repository\org\springframework\boot\spring-boot-starter-tomcat\2.3.5.RELEASE\spring-boot-starter-tomcat-2.3.5.RELEASE.jar;D:\localfile\apache-maven-3.5.4\repository\org\apache\tomcat\embed\tomcat-embed-core\9.0.39\tomcat-embed-core-9.0.39.jar;D:\localfile\apache-maven-3.5.4\repository\org\glassfish\jakarta.el\3.0.3\jakarta.el-3.0.3.jar;D:\localfile\apache-maven-3.5.4\repository\org\apache\tomcat\embed\tomcat-embed-websocket\9.0.39\tomcat-embed-websocket-9.0.39.jar;D:\localfile\apache-maven-3.5.4\repository\org\springframework\spring-web\5.2.10.RELEASE\spring-web-5.2.10.RELEASE.jar;D:\localfile\apache-maven-3.5.4\repository\org\springframework\spring-beans\5.2.10.RELEASE\spring-beans-5.2.10.RELEASE.jar;D:\localfile\apache-maven-3.5.4\repository\org\springframework\spring-webmvc\5.2.10.RELEASE\spring-webmvc-5.2.10.RELEASE.jar;D:\localfile\apache-maven-3.5.4\repository\org\springframework\spring-aop\5.2.10.RELEASE\spring-aop-5.2.10.RELEASE.jar;D:\localfile\apache-maven-3.5.4\repository\org\springframework\spring-context\5.2.10.RELEASE\spring-context-5.2.10.RELEASE.jar;D:\localfile\apache-maven-3.5.4\repository\org\springframework\spring-expression\5.2.10.RELEASE\spring-expression-5.2.10.RELEASE.jar;D:\localfile\apache-maven-3.5.4\repository\com\baomidou\mybatis-plus-boot-starter\2.3\mybatis-plus-boot-starter-2.3.jar;D:\localfile\apache-maven-3.5.4\repository\com\baomidou\mybatis-plus\2.3\mybatis-plus-2.3.jar;D:\localfile\apache-maven-3.5.4\repository\com\baomidou\mybatis-plus-support\2.3\mybatis-plus-support-2.3.jar;D:\localfile\apache-maven-3.5.4\repository\com\baomidou\mybatis-plus-core\2.3\mybatis-plus-core-2.3.jar;D:\localfile\apache-maven-3.5.4\repository\com\github\jsqlparser\jsqlparser\1.1\jsqlparser-1.1.jar;D:\localfile\apache-maven-3.5.4\repository\org\mybatis\mybatis-spring\1.3.2\mybatis-spring-1.3.2.jar;D:\localfile\apache-maven-3.5.4\repository\org\mybatis\mybatis\3.4.6\mybatis-3.4.6.jar;D:\localfile\apache-maven-3.5.4\repository\com\baomidou\mybatis-plus-generate\2.3\mybatis-plus-generate-2.3.jar;D:\localfile\apache-maven-3.5.4\repository\org\springframework\boot\spring-boot-autoconfigure\2.3.5.RELEASE\spring-boot-autoconfigure-2.3.5.RELEASE.jar;D:\localfile\apache-maven-3.5.4\repository\org\springframework\boot\spring-boot-starter-jdbc\2.3.5.RELEASE\spring-boot-starter-jdbc-2.3.5.RELEASE.jar;D:\localfile\apache-maven-3.5.4\repository\com\zaxxer\HikariCP\3.4.5\HikariCP-3.4.5.jar;D:\localfile\apache-maven-3.5.4\repository\org\springframework\spring-jdbc\5.2.10.RELEASE\spring-jdbc-5.2.10.RELEASE.jar;D:\localfile\apache-maven-3.5.4\repository\org\springframework\spring-tx\5.2.10.RELEASE\spring-tx-5.2.10.RELEASE.jar;D:\localfile\apache-maven-3.5.4\repository\mysql\mysql-connector-java\8.0.22\mysql-connector-java-8.0.22.jar;D:\localfile\apache-maven-3.5.4\repository\org\projectlombok\lombok\1.18.16\lombok-1.18.16.jar;D:\localfile\apache-maven-3.5.4\repository\org\slf4j\slf4j-api\1.7.30\slf4j-api-1.7.30.jar;D:\localfile\apache-maven-3.5.4\repository\org\springframework\spring-core\5.2.10.RELEASE\spring-core-5.2.10.RELEASE.jar;D:\localfile\apache-maven-3.5.4\repository\org\springframework\spring-jcl\5.2.10.RELEASE\spring-jcl-5.2.10.RELEASE.jar;D:\Program Files\JetBrains\IntelliJ IDEA 2019.1.3\lib\idea_rt.jar" com.itsource.yanhua.SpringbootMybatisplusApplication
Connected to the target VM, address: '127.0.0.1:52210', transport: 'socket'

  .   ____          _            __ _ _
 /\\ / ___'_ __ _ _(_)_ __  __ _ \ \ \ \
( ( )\___ | '_ | '_| | '_ \/ _` | \ \ \ \
 \\/  ___)| |_)| | | | | || (_| |  ) ) ) )
  '  |____| .__|_| |_|_| |_\__, | / / / /
 =========|_|==============|___/=/_/_/_/
 :: Spring Boot ::        (v2.3.5.RELEASE)

2020-11-16 16:50:27.342  INFO 23068 --- [           main] c.i.y.SpringbootMybatisplusApplication   : Starting SpringbootMybatisplusApplication on WIN-3A7O8CVIB4J with PID 23068 (D:\ideaWork\springboot-mybatisplus\target\classes started by win-20190221 in D:\ideaWork\springboot-mybatisplus)
2020-11-16 16:50:27.346  INFO 23068 --- [           main] c.i.y.SpringbootMybatisplusApplication   : No active profile set, falling back to default profiles: default
2020-11-16 16:50:28.196  WARN 23068 --- [           main] o.m.s.mapper.ClassPathMapperScanner      : No MyBatis mapper was found in '[com.itsource.yanhua]' package. Please check your configuration.
2020-11-16 16:50:28.540 ERROR 23068 --- [           main] o.a.catalina.core.AprLifecycleListener   : An incompatible version [1.2.8] of the Apache Tomcat Native library is installed, while Tomcat requires version [1.2.14]
2020-11-16 16:50:28.880  INFO 23068 --- [           main] o.s.b.w.embedded.tomcat.TomcatWebServer  : Tomcat initialized with port(s): 8088 (http)
2020-11-16 16:50:28.895  INFO 23068 --- [           main] o.apache.catalina.core.StandardService   : Starting service [Tomcat]
2020-11-16 16:50:28.895  INFO 23068 --- [           main] org.apache.catalina.core.StandardEngine  : Starting Servlet engine: [Apache Tomcat/9.0.39]
2020-11-16 16:50:29.075  INFO 23068 --- [           main] o.a.c.c.C.[Tomcat].[localhost].[/]       : Initializing Spring embedded WebApplicationContext
2020-11-16 16:50:29.075  INFO 23068 --- [           main] w.s.c.ServletWebServerApplicationContext : Root WebApplicationContext: initialization completed in 1652 ms
2020-11-16 16:50:29.363  INFO 23068 --- [           main] o.s.s.concurrent.ThreadPoolTaskExecutor  : Initializing ExecutorService 'applicationTaskExecutor'
2020-11-16 16:50:29.705  INFO 23068 --- [           main] com.zaxxer.hikari.HikariDataSource       : HikariPool-1 - Starting...
2020-11-16 16:50:31.319 ERROR 23068 --- [           main] com.zaxxer.hikari.pool.HikariPool        : HikariPool-1 - Exception during pool initialization.

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 specific time zone value if you want to utilize time zone support.
	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:129) ~[mysql-connector-java-8.0.22.jar:8.0.22]
	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97) ~[mysql-connector-java-8.0.22.jar:8.0.22]
	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:89) ~[mysql-connector-java-8.0.22.jar:8.0.22]
	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:63) ~[mysql-connector-java-8.0.22.jar:8.0.22]
	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:73) ~[mysql-connector-java-8.0.22.jar:8.0.22]
	at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:76) ~[mysql-connector-java-8.0.22.jar:8.0.22]
	at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:836) ~[mysql-connector-java-8.0.22.jar:8.0.22]
	at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:456) ~[mysql-connector-java-8.0.22.jar:8.0.22]
	at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:246) ~[mysql-connector-java-8.0.22.jar:8.0.22]
	at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:198) ~[mysql-connector-java-8.0.22.jar:8.0.22]
	at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:138) ~[HikariCP-3.4.5.jar:na]
	at com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:358) ~[HikariCP-3.4.5.jar:na]
	at com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:206) ~[HikariCP-3.4.5.jar:na]
	at com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:477) [HikariCP-3.4.5.jar:na]
	at com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:560) [HikariCP-3.4.5.jar:na]
	at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:115) [HikariCP-3.4.5.jar:na]
	at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:112) [HikariCP-3.4.5.jar:na]
	at com.baomidou.mybatisplus.toolkit.GlobalConfigUtils.setMetaData(GlobalConfigUtils.java:187) [mybatis-plus-support-2.3.jar:na]
	at com.baomidou.mybatisplus.spring.MybatisSqlSessionFactoryBean.buildSqlSessionFactory(MybatisSqlSessionFactoryBean.java:560) [mybatis-plus-core-2.3.jar:na]
	at com.baomidou.mybatisplus.spring.MybatisSqlSessionFactoryBean.afterPropertiesSet(MybatisSqlSessionFactoryBean.java:385) [mybatis-plus-core-2.3.jar:na]
	at com.baomidou.mybatisplus.spring.MybatisSqlSessionFactoryBean.getObject(MybatisSqlSessionFactoryBean.java:608) [mybatis-plus-core-2.3.jar:na]
	at com.baomidou.mybatisplus.spring.boot.starter.MybatisPlusAutoConfiguration.sqlSessionFactory(MybatisPlusAutoConfiguration.java:180) [mybatis-plus-boot-starter-2.3.jar:na]
	at com.baomidou.mybatisplus.spring.boot.starter.MybatisPlusAutoConfiguration$$EnhancerBySpringCGLIB$$46a6cd22.CGLIB$sqlSessionFactory$0(<generated>) [mybatis-plus-boot-starter-2.3.jar:na]
	at com.baomidou.mybatisplus.spring.boot.starter.MybatisPlusAutoConfiguration$$EnhancerBySpringCGLIB$$46a6cd22$$FastClassBySpringCGLIB$$e556ec19.invoke(<generated>) [mybatis-plus-boot-starter-2.3.jar:na]
	at org.springframework.cglib.proxy.MethodProxy.invokeSuper(MethodProxy.java:244) [spring-core-5.2.10.RELEASE.jar:5.2.10.RELEASE]
	at org.springframework.context.annotation.ConfigurationClassEnhancer$BeanMethodInterceptor.intercept(ConfigurationClassEnhancer.java:331) [spring-context-5.2.10.RELEASE.jar:5.2.10.RELEASE]
	at com.baomidou.mybatisplus.spring.boot.starter.MybatisPlusAutoConfiguration$$EnhancerBySpringCGLIB$$46a6cd22.sqlSessionFactory(<generated>) [mybatis-plus-boot-starter-2.3.jar:na]
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_172]
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[na:1.8.0_172]
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_172]
	at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_172]
	at org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:154) [spring-beans-5.2.10.RELEASE.jar:5.2.10.RELEASE]
	at org.springframework.beans.factory.support.ConstructorResolver.instantiate(ConstructorResolver.java:650) [spring-beans-5.2.10.RELEASE.jar:5.2.10.RELEASE]
	at org.springframework.beans.factory.support.ConstructorResolver.instantiateUsingFactoryMethod(ConstructorResolver.java:635) [spring-beans-5.2.10.RELEASE.jar:5.2.10.RELEASE]
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.instantiateUsingFactoryMethod(AbstractAutowireCapableBeanFactory.java:1336) [spring-beans-5.2.10.RELEASE.jar:5.2.10.RELEASE]
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1176) [spring-beans-5.2.10.RELEASE.jar:5.2.10.RELEASE]
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:556) [spring-beans-5.2.10.RELEASE.jar:5.2.10.RELEASE]
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:516) [spring-beans-5.2.10.RELEASE.jar:5.2.10.RELEASE]
	at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:324) [spring-beans-5.2.10.RELEASE.jar:5.2.10.RELEASE]
	at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234) ~[spring-beans-5.2.10.RELEASE.jar:5.2.10.RELEASE]
	at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:322) [spring-beans-5.2.10.RELEASE.jar:5.2.10.RELEASE]
	at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:202) [spring-beans-5.2.10.RELEASE.jar:5.2.10.RELEASE]
	at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:897) ~[spring-beans-5.2.10.RELEASE.jar:5.2.10.RELEASE]
	at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:879) ~[spring-context-5.2.10.RELEASE.jar:5.2.10.RELEASE]
	at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:551) ~[spring-context-5.2.10.RELEASE.jar:5.2.10.RELEASE]
	at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.refresh(ServletWebServerApplicationContext.java:143) ~[spring-boot-2.3.5.RELEASE.jar:2.3.5.RELEASE]
	at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:758) ~[spring-boot-2.3.5.RELEASE.jar:2.3.5.RELEASE]
	at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:750) ~[spring-boot-2.3.5.RELEASE.jar:2.3.5.RELEASE]
	at org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:405) ~[spring-boot-2.3.5.RELEASE.jar:2.3.5.RELEASE]
	at org.springframework.boot.SpringApplication.run(SpringApplication.java:315) ~[spring-boot-2.3.5.RELEASE.jar:2.3.5.RELEASE]
	at org.springframework.boot.SpringApplication.run(SpringApplication.java:1237) ~[spring-boot-2.3.5.RELEASE.jar:2.3.5.RELEASE]
	at org.springframework.boot.SpringApplication.run(SpringApplication.java:1226) ~[spring-boot-2.3.5.RELEASE.jar:2.3.5.RELEASE]
	at com.itsource.yanhua.SpringbootMybatisplusApplication.main(SpringbootMybatisplusApplication.java:10) ~[classes/:na]
Caused by: 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 property) to use a more specific time zone value if you want to utilize time zone support.
	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[na:1.8.0_172]
	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) ~[na:1.8.0_172]
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[na:1.8.0_172]
	at java.lang.reflect.Constructor.newInstance(Constructor.java:423) ~[na:1.8.0_172]
	at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:61) ~[mysql-connector-java-8.0.22.jar:8.0.22]
	at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:85) ~[mysql-connector-java-8.0.22.jar:8.0.22]
	at com.mysql.cj.util.TimeUtil.getCanonicalTimezone(TimeUtil.java:134) ~[mysql-connector-java-8.0.22.jar:8.0.22]
	at com.mysql.cj.protocol.a.NativeProtocol.configureTimezone(NativeProtocol.java:2186) ~[mysql-connector-java-8.0.22.jar:8.0.22]
	at com.mysql.cj.protocol.a.NativeProtocol.initServerSession(NativeProtocol.java:2209) ~[mysql-connector-java-8.0.22.jar:8.0.22]
	at com.mysql.cj.jdbc.ConnectionImpl.initializePropsFromServer(ConnectionImpl.java:1318) ~[mysql-connector-java-8.0.22.jar:8.0.22]
	at com.mysql.cj.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:967) ~[mysql-connector-java-8.0.22.jar:8.0.22]
	at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:826) ~[mysql-connector-java-8.0.22.jar:8.0.22]
	... 46 common frames omitted

2020-11-16 16:50:31.323  WARN 23068 --- [           main] ConfigServletWebServerApplicationContext : Exception encountered during context initialization - cancelling refresh attempt: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sqlSessionFactory' defined in class path resource [com/baomidou/mybatisplus/spring/boot/starter/MybatisPlusAutoConfiguration.class]: Bean instantiation via factory method failed; nested exception is org.springframework.beans.BeanInstantiationException: Failed to instantiate [org.apache.ibatis.session.SqlSessionFactory]: Factory method 'sqlSessionFactory' threw exception; nested exception is com.baomidou.mybatisplus.exceptions.MybatisPlusException: Error: GlobalConfigUtils setMetaData Fail !  Cause: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 specific time zone value if you want to utilize time zone support.
2020-11-16 16:50:31.324  INFO 23068 --- [           main] o.s.s.concurrent.ThreadPoolTaskExecutor  : Shutting down ExecutorService 'applicationTaskExecutor'
2020-11-16 16:50:31.328  INFO 23068 --- [           main] o.apache.catalina.core.StandardService   : Stopping service [Tomcat]
2020-11-16 16:50:31.340  INFO 23068 --- [           main] ConditionEvaluationReportLoggingListener : 

Error starting ApplicationContext. To display the conditions report re-run your application with 'debug' enabled.
2020-11-16 16:50:31.354 ERROR 23068 --- [           main] o.s.boot.SpringApplication               : Application run failed

org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sqlSessionFactory' defined in class path resource [com/baomidou/mybatisplus/spring/boot/starter/MybatisPlusAutoConfiguration.class]: Bean instantiation via factory method failed; nested exception is org.springframework.beans.BeanInstantiationException: Failed to instantiate [org.apache.ibatis.session.SqlSessionFactory]: Factory method 'sqlSessionFactory' threw exception; nested exception is com.baomidou.mybatisplus.exceptions.MybatisPlusException: Error: GlobalConfigUtils setMetaData Fail !  Cause: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 specific time zone value if you want to utilize time zone support.
	at org.springframework.beans.factory.support.ConstructorResolver.instantiate(ConstructorResolver.java:655) ~[spring-beans-5.2.10.RELEASE.jar:5.2.10.RELEASE]
	at org.springframework.beans.factory.support.ConstructorResolver.instantiateUsingFactoryMethod(ConstructorResolver.java:635) ~[spring-beans-5.2.10.RELEASE.jar:5.2.10.RELEASE]
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.instantiateUsingFactoryMethod(AbstractAutowireCapableBeanFactory.java:1336) ~[spring-beans-5.2.10.RELEASE.jar:5.2.10.RELEASE]
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1176) ~[spring-beans-5.2.10.RELEASE.jar:5.2.10.RELEASE]
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:556) ~[spring-beans-5.2.10.RELEASE.jar:5.2.10.RELEASE]
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:516) ~[spring-beans-5.2.10.RELEASE.jar:5.2.10.RELEASE]
	at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:324) ~[spring-beans-5.2.10.RELEASE.jar:5.2.10.RELEASE]
	at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234) ~[spring-beans-5.2.10.RELEASE.jar:5.2.10.RELEASE]
	at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:322) ~[spring-beans-5.2.10.RELEASE.jar:5.2.10.RELEASE]
	at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:202) ~[spring-beans-5.2.10.RELEASE.jar:5.2.10.RELEASE]
	at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:897) ~[spring-beans-5.2.10.RELEASE.jar:5.2.10.RELEASE]
	at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:879) ~[spring-context-5.2.10.RELEASE.jar:5.2.10.RELEASE]
	at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:551) ~[spring-context-5.2.10.RELEASE.jar:5.2.10.RELEASE]
	at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.refresh(ServletWebServerApplicationContext.java:143) ~[spring-boot-2.3.5.RELEASE.jar:2.3.5.RELEASE]
	at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:758) [spring-boot-2.3.5.RELEASE.jar:2.3.5.RELEASE]
	at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:750) [spring-boot-2.3.5.RELEASE.jar:2.3.5.RELEASE]
	at org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:405) [spring-boot-2.3.5.RELEASE.jar:2.3.5.RELEASE]
	at org.springframework.boot.SpringApplication.run(SpringApplication.java:315) [spring-boot-2.3.5.RELEASE.jar:2.3.5.RELEASE]
	at org.springframework.boot.SpringApplication.run(SpringApplication.java:1237) [spring-boot-2.3.5.RELEASE.jar:2.3.5.RELEASE]
	at org.springframework.boot.SpringApplication.run(SpringApplication.java:1226) [spring-boot-2.3.5.RELEASE.jar:2.3.5.RELEASE]
	at com.itsource.yanhua.SpringbootMybatisplusApplication.main(SpringbootMybatisplusApplication.java:10) [classes/:na]
Caused by: org.springframework.beans.BeanInstantiationException: Failed to instantiate [org.apache.ibatis.session.SqlSessionFactory]: Factory method 'sqlSessionFactory' threw exception; nested exception is com.baomidou.mybatisplus.exceptions.MybatisPlusException: Error: GlobalConfigUtils setMetaData Fail !  Cause: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 specific time zone value if you want to utilize time zone support.
	at org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:185) ~[spring-beans-5.2.10.RELEASE.jar:5.2.10.RELEASE]
	at org.springframework.beans.factory.support.ConstructorResolver.instantiate(ConstructorResolver.java:650) ~[spring-beans-5.2.10.RELEASE.jar:5.2.10.RELEASE]
	... 20 common frames omitted
Caused by: com.baomidou.mybatisplus.exceptions.MybatisPlusException: Error: GlobalConfigUtils setMetaData Fail !  Cause: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 specific time zone value if you want to utilize time zone support.
	at com.baomidou.mybatisplus.toolkit.GlobalConfigUtils.setMetaData(GlobalConfigUtils.java:196) ~[mybatis-plus-support-2.3.jar:na]
	at com.baomidou.mybatisplus.spring.MybatisSqlSessionFactoryBean.buildSqlSessionFactory(MybatisSqlSessionFactoryBean.java:560) ~[mybatis-plus-core-2.3.jar:na]
	at com.baomidou.mybatisplus.spring.MybatisSqlSessionFactoryBean.afterPropertiesSet(MybatisSqlSessionFactoryBean.java:385) ~[mybatis-plus-core-2.3.jar:na]
	at com.baomidou.mybatisplus.spring.MybatisSqlSessionFactoryBean.getObject(MybatisSqlSessionFactoryBean.java:608) ~[mybatis-plus-core-2.3.jar:na]
	at com.baomidou.mybatisplus.spring.boot.starter.MybatisPlusAutoConfiguration.sqlSessionFactory(MybatisPlusAutoConfiguration.java:180) ~[mybatis-plus-boot-starter-2.3.jar:na]
	at com.baomidou.mybatisplus.spring.boot.starter.MybatisPlusAutoConfiguration$$EnhancerBySpringCGLIB$$46a6cd22.CGLIB$sqlSessionFactory$0(<generated>) ~[mybatis-plus-boot-starter-2.3.jar:na]
	at com.baomidou.mybatisplus.spring.boot.starter.MybatisPlusAutoConfiguration$$EnhancerBySpringCGLIB$$46a6cd22$$FastClassBySpringCGLIB$$e556ec19.invoke(<generated>) ~[mybatis-plus-boot-starter-2.3.jar:na]
	at org.springframework.cglib.proxy.MethodProxy.invokeSuper(MethodProxy.java:244) ~[spring-core-5.2.10.RELEASE.jar:5.2.10.RELEASE]
	at org.springframework.context.annotation.ConfigurationClassEnhancer$BeanMethodInterceptor.intercept(ConfigurationClassEnhancer.java:331) ~[spring-context-5.2.10.RELEASE.jar:5.2.10.RELEASE]
	at com.baomidou.mybatisplus.spring.boot.starter.MybatisPlusAutoConfiguration$$EnhancerBySpringCGLIB$$46a6cd22.sqlSessionFactory(<generated>) ~[mybatis-plus-boot-starter-2.3.jar:na]
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_172]
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[na:1.8.0_172]
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_172]
	at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_172]
	at org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:154) ~[spring-beans-5.2.10.RELEASE.jar:5.2.10.RELEASE]
	... 21 common frames omitted

Disconnected from the target VM, address: '127.0.0.1:52210', transport: 'socket'

Process finished with exit code 1

二：解决（在url上加上时区）

url: jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=utf8&serverTimezone=UTC
码农巅峰
关注
专栏目录
mysql数据库The server time zone value '�й���׼ʱ��' is unrecogni等报错解决
程序媛乐园
11-12 1万+
MySQL连接报错 spring.datasource.url连接信息出问题。 报错信息 { "timestamp": "2019-11-12T11:07:30.870+0000", "status": 500, "error": "Internal Server Error", "message": "nested exception is org.apache.ibatis.e...
Mysql解决报错java.sql.SQLException: The server time zone value ‘Öйú±ê׼ʱ¼ä‘ is unrecognized解决方案
北溟南风起
09-02 516
Mysql解决报错java.sql.SQLException: The server time zone value ‘Öйú±ê׼ʱ¼ä’ is unrecognized解决方案 原因： 系mysql系统时区相关 比较靠谱的解决办法： 通过mysql命令行改回北京时区（东8区） 输入指令进入启动mysql net start mysql 输入用户名和密码进入mysql mysql -u root -p 输入自己的数据库密码 查看现有的mysql时区 select curtime(
SpringBoot 出现java.sql.SQLException:The server time zone value。服务器时区问题
m0_47885637的博客
07-28 232
在错误信息中提示You must configure either the server or JDBC driver (via the serverTimezone configuration property) 在SpringBoot中使用JDBC连接MySql时出现： java.sql.SQLException:The server time zone value '�й���׼ʱ��' is unrecognized or represents more than one time zone. Yo
Springboot+JPA启动时出现的问题SpringBoot运行报错——java.sql.SQLException: The server time zone value '�й���׼ʱ��'
weixin_45089791的博客
11-06 1030
报错信息为 SpringBoot运行报错——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 th...
spring boot 项目报错 java.sql.SQLException: The server time zone value ‘�й���׼ʱ��‘
qq_41649001的博客
07-21 640
控制台信息 问题原因 因为mysql-connection-java版本导致时区的问题。可以在自己的SpringBoot配置文件中,对数据库连接信息中添加好时区相关配置 解决方式
java.sql.SQLException: The server time zone value ‘�й���׼ʱ��‘ is unrecognized or represents more tha
ITwuwei的博客
01-07 148
在jdbc连接数据库时可能会遇到这样的错误： 解决方法： 在数据库后面加上： ?useSSL=false&serverTimezone=UTC jdbc:mysql://localhost:3306/db1?useSSL=false&serverTimezone=UTC 这样就完美解决啦！
异常：java.sql.SQLException: The server time zone value ‘?й???????’ is unrecognized or represents more
12-14
当你尝试连接到MySQL数据库时，可能会遇到一个特定的异常：“java.sql.SQLException: The server time zone value ‘?й???????’ is unrecognized or represents more than one time zone”。这个错误表明服务器...
解决IDEA错误 Cause: java.sql.SQLException: The server time zone value的问题
08-18
标题中的问题“Cause: java.sql.SQLException: The server time zone value”是Java开发者在使用IDEA（IntelliJ IDEA）进行数据库连接时常见的错误提示。这个错误通常发生在尝试连接到MySQL等SQL数据库时，由于...
java.sql.SQLException: The server time zone value ‘�й���׼ʱ��‘ is unrecognized or represents more...
qq_46018521的博客
09-11 203
报错原因：时区不对，是由于mysql-connection-java版本导致时区的问题。
SpringBoot连接数库错误ava.sql.SQLException: The server time zone value '�й���׼ʱ��' is unrecognized or repr
MADE_哒哒
08-05 3478
报的错误信息：ava.sql.SQLException: The servertimezonevalue'�й���׼ʱ��'is unrecognizedor represents more than onetimezone. You must configure either the serveror JDBC driver (via the serverTimezone c...
spring boot 项目报错 java.sql.SQLException: The server time zone value ‘�й���׼ʱ��‘ is unrecognized解决办法
ZZPJackie的博客
07-02 2155
spring boot 项目报错 java.sql.SQLException: The server time zone value '�й���׼ʱ��' is unrecognized解决办法如何插入一段漂亮的代码片生成一个适合你的列表创建一个表格设定内容居中、居左、居右SmartyPants创建一个自定义列表如何创建一个注脚注释也是必不可少的KaTeX数学公式新的甘特图功能，丰富你的文章UML 图表FLowchart流程图导出与导入导出导入 https://blog.csdn.net/qq_43371
DBEAVER连接MySQL运行报错The server time zone value 'Öйú±ê׼ʱ¼ä' is unrecognized or represents more than
c851204293的博客
01-02 376
time zone 时区错误 DBEAVER连接MySQL运行报错The server time zone value 'Öйú±ê׼ʱ¼ä' is unrecognized or represents more than one time zone 使用root用户登录mysql，按照如下图所示操作即可。 show variables like '%time_zone%'; SYSTE...
springboot报错The server time zone value 'Öйú±ê׼ʱ¼ä' is unrecognized or represents more than one
cqc__c的博客
12-30 6539
spring.datasource.url=jdbc:mysql://localhost:3306/exercise?serverTimezone=GMT%2B8&amp;useUnicode=true&amp;characterEncoding=utf-8 mysql默认服务器时区问题，将数据库连接修改成上述那样，就能解决...
MySql错误：java.sql.SQLException: The server time zone value '�й���׼ʱ��' is unrecognized or represents
TaoYuan
04-29 3968
错误描述 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’ ...
java.sql.SQLException: The server time zone value '�й���׼ʱ��' is unrecognized or represents more tha
lihuayingmail的专栏
06-12 3553
serverTimezone=CTT
SQLException: The server time zone value ‘�й���׼ʱ��’ is unrecognized
koreyoshi326的博客
12-12 1万+
SQLException: The server time zone value ‘�й���׼ʱ��’ is unrecognized
[MySQL] The server time zone value 'Öйú±ê׼ʱ¼ä' is unrecognized or represents more than...的解决方案
相信的心就是你的魔法！
09-01 790
问题描述： JDBC连接数据库报“The server time zone value 'Öйú±ê׼ʱ¼ä' is unrecognized or represents more than one time zone”的错误。此问题出现在MySQL8.0版本。 解决方案： 在MySQL连接URL后面添加： ?serverTimezone=GMT%2B8 示例： jdbc:m...
java连接mysql出现The server time zone value '�й���׼ʱ��' is unrecognized的解决方法
热门推荐
qq_36470898的博客
07-17 2万+
java连接mysql出现The server time zone value '�й���׼ʱ��' is unrecognized的解决方法 在Idea中连接数据库是抛出The server time zone value ‘�й���׼ʱ��’ is unrecogni错误 原因是因为使用了Mysql Connector/J 6.x以上的版本，然后就报了时区的错误。 解决办法在配置url中添...
mysql:The server time zone value 'Öйú±ê׼ʱ¼ä' is unrecognized or represents more than one time zon
weixin_36997847的博客
11-15 789
1.进入命令行界面 2.mysql -uroot -p 3.输入密码 4.show variables like '%time_zone%'; 5.如果显示如下，进行第6步 6.set global time_zone='+8:00'; 7.完成。
java.sql.SQLException: The server time zone value '�й���׼ʱ��' is unrecognized or represents more tha...
最新发布
06-06
在连接MySQL数据库的URL后面加上参数 `serverTimezone=UTC`，例如： ``` jdbc:mysql://localhost:3306/mydatabase?serverTimezone=UTC ``` 2. 修改MySQL的时区配置： 在MySQL命令行中执行以下命令： ``` SET ...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值