springboot启动异常（Could not create connection to database server. Attempted reconnect 3 times. Giving）

最新推荐文章于 2024-04-18 01:00:00 发布
最新推荐文章于 2024-04-18 01:00:00 发布
阅读量3.3k 收藏
点赞数 1
分类专栏： springBoot启动异常 文章标签： java
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/l13880647015/article/details/107508950
版权

一：springboot启动异常java.sql.SQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up

D:\localfile\jdk-8u172-windows-i586\bin\java.exe -agentlib:jdwp=transport=dt_socket,address=127.0.0.1:63752,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\spring-family-mytemplate\spring-family-client\target\classes;D:\ideaWork\spring-family-mytemplate\spring-family-common\target\classes;D:\localfile\apache-maven-3.5.4\repository\org\springframework\boot\spring-boot-starter-data-redis\2.3.0.RELEASE\spring-boot-starter-data-redis-2.3.0.RELEASE.jar;D:\localfile\apache-maven-3.5.4\repository\org\springframework\data\spring-data-redis\2.3.0.RELEASE\spring-data-redis-2.3.0.RELEASE.jar;D:\localfile\apache-maven-3.5.4\repository\org\springframework\data\spring-data-keyvalue\2.3.0.RELEASE\spring-data-keyvalue-2.3.0.RELEASE.jar;D:\localfile\apache-maven-3.5.4\repository\org\springframework\data\spring-data-commons\2.3.0.RELEASE\spring-data-commons-2.3.0.RELEASE.jar;D:\localfile\apache-maven-3.5.4\repository\org\springframework\spring-tx\5.2.6.RELEASE\spring-tx-5.2.6.RELEASE.jar;D:\localfile\apache-maven-3.5.4\repository\org\springframework\spring-oxm\5.2.6.RELEASE\spring-oxm-5.2.6.RELEASE.jar;D:\localfile\apache-maven-3.5.4\repository\org\springframework\spring-context-support\5.2.6.RELEASE\spring-context-support-5.2.6.RELEASE.jar;D:\localfile\apache-maven-3.5.4\repository\io\lettuce\lettuce-core\5.3.0.RELEASE\lettuce-core-5.3.0.RELEASE.jar;D:\localfile\apache-maven-3.5.4\repository\io\netty\netty-common\4.1.49.Final\netty-common-4.1.49.Final.jar;D:\localfile\apache-maven-3.5.4\repository\io\netty\netty-handler\4.1.49.Final\netty-handler-4.1.49.Final.jar;D:\localfile\apache-maven-3.5.4\repository\io\netty\netty-resolver\4.1.49.Final\netty-resolver-4.1.49.Final.jar;D:\localfile\apache-maven-3.5.4\repository\io\netty\netty-buffer\4.1.49.Final\netty-buffer-4.1.49.Final.jar;D:\localfile\apache-maven-3.5.4\repository\io\netty\netty-codec\4.1.49.Final\netty-codec-4.1.49.Final.jar;D:\localfile\apache-maven-3.5.4\repository\io\netty\netty-transport\4.1.49.Final\netty-transport-4.1.49.Final.jar;D:\localfile\apache-maven-3.5.4\repository\io\projectreactor\reactor-core\3.3.5.RELEASE\reactor-core-3.3.5.RELEASE.jar;D:\localfile\apache-maven-3.5.4\repository\org\reactivestreams\reactive-streams\1.0.3\reactive-streams-1.0.3.jar;D:\localfile\apache-maven-3.5.4\repository\mysql\mysql-connector-java\8.0.20\mysql-connector-java-8.0.20.jar;D:\localfile\apache-maven-3.5.4\repository\com\alibaba\druid-spring-boot-starter\1.1.10\druid-spring-boot-starter-1.1.10.jar;D:\localfile\apache-maven-3.5.4\repository\com\alibaba\druid\1.1.10\druid-1.1.10.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\boot\spring-boot-autoconfigure\2.3.0.RELEASE\spring-boot-autoconfigure-2.3.0.RELEASE.jar;D:\localfile\apache-maven-3.5.4\repository\com\baomidou\mybatis-plus-boot-starter\3.1.0\mybatis-plus-boot-starter-3.1.0.jar;D:\localfile\apache-maven-3.5.4\repository\com\baomidou\mybatis-plus\3.1.0\mybatis-plus-3.1.0.jar;D:\localfile\apache-maven-3.5.4\repository\org\springframework\boot\spring-boot-starter-jdbc\2.3.0.RELEASE\spring-boot-starter-jdbc-2.3.0.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.6.RELEASE\spring-jdbc-5.2.6.RELEASE.jar;D:\localfile\apache-maven-3.5.4\repository\com\baomidou\mybatis-plus-generator\3.1.0\mybatis-plus-generator-3.1.0.jar;D:\localfile\apache-maven-3.5.4\repository\com\baomidou\mybatis-plus-extension\3.1.0\mybatis-plus-extension-3.1.0.jar;D:\localfile\apache-maven-3.5.4\repository\com\baomidou\mybatis-plus-core\3.1.0\mybatis-plus-core-3.1.0.jar;D:\localfile\apache-maven-3.5.4\repository\com\baomidou\mybatis-plus-annotation\3.1.0\mybatis-plus-annotation-3.1.0.jar;D:\localfile\apache-maven-3.5.4\repository\org\mybatis\mybatis\3.5.0\mybatis-3.5.0.jar;D:\localfile\apache-maven-3.5.4\repository\com\github\jsqlparser\jsqlparser\1.4\jsqlparser-1.4.jar;D:\localfile\apache-maven-3.5.4\repository\org\mybatis\mybatis-spring\2.0.0\mybatis-spring-2.0.0.jar;D:\localfile\apache-maven-3.5.4\repository\org\freemarker\freemarker\2.3.30\freemarker-2.3.30.jar;D:\localfile\apache-maven-3.5.4\repository\org\springframework\boot\spring-boot-starter-web\2.3.0.RELEASE\spring-boot-starter-web-2.3.0.RELEASE.jar;D:\localfile\apache-maven-3.5.4\repository\org\springframework\boot\spring-boot-starter\2.3.0.RELEASE\spring-boot-starter-2.3.0.RELEASE.jar;D:\localfile\apache-maven-3.5.4\repository\org\springframework\boot\spring-boot\2.3.0.RELEASE\spring-boot-2.3.0.RELEASE.jar;D:\localfile\apache-maven-3.5.4\repository\org\springframework\boot\spring-boot-starter-logging\2.3.0.RELEASE\spring-boot-starter-logging-2.3.0.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.2\log4j-to-slf4j-2.13.2.jar;D:\localfile\apache-maven-3.5.4\repository\org\apache\logging\log4j\log4j-api\2.13.2\log4j-api-2.13.2.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.0.RELEASE\spring-boot-starter-json-2.3.0.RELEASE.jar;D:\localfile\apache-maven-3.5.4\repository\com\fasterxml\jackson\core\jackson-databind\2.11.0\jackson-databind-2.11.0.jar;D:\localfile\apache-maven-3.5.4\repository\com\fasterxml\jackson\core\jackson-annotations\2.11.0\jackson-annotations-2.11.0.jar;D:\localfile\apache-maven-3.5.4\repository\com\fasterxml\jackson\core\jackson-core\2.11.0\jackson-core-2.11.0.jar;D:\localfile\apache-maven-3.5.4\repository\com\fasterxml\jackson\datatype\jackson-datatype-jdk8\2.11.0\jackson-datatype-jdk8-2.11.0.jar;D:\localfile\apache-maven-3.5.4\repository\com\fasterxml\jackson\datatype\jackson-datatype-jsr310\2.11.0\jackson-datatype-jsr310-2.11.0.jar;D:\localfile\apache-maven-3.5.4\repository\com\fasterxml\jackson\module\jackson-module-parameter-names\2.11.0\jackson-module-parameter-names-2.11.0.jar;D:\localfile\apache-maven-3.5.4\repository\org\springframework\boot\spring-boot-starter-tomcat\2.3.0.RELEASE\spring-boot-starter-tomcat-2.3.0.RELEASE.jar;D:\localfile\apache-maven-3.5.4\repository\org\apache\tomcat\embed\tomcat-embed-core\9.0.35\tomcat-embed-core-9.0.35.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.35\tomcat-embed-websocket-9.0.35.jar;D:\localfile\apache-maven-3.5.4\repository\org\springframework\spring-web\5.2.6.RELEASE\spring-web-5.2.6.RELEASE.jar;D:\localfile\apache-maven-3.5.4\repository\org\springframework\spring-beans\5.2.6.RELEASE\spring-beans-5.2.6.RELEASE.jar;D:\localfile\apache-maven-3.5.4\repository\org\springframework\spring-webmvc\5.2.6.RELEASE\spring-webmvc-5.2.6.RELEASE.jar;D:\localfile\apache-maven-3.5.4\repository\org\springframework\spring-aop\5.2.6.RELEASE\spring-aop-5.2.6.RELEASE.jar;D:\localfile\apache-maven-3.5.4\repository\org\springframework\spring-context\5.2.6.RELEASE\spring-context-5.2.6.RELEASE.jar;D:\localfile\apache-maven-3.5.4\repository\org\springframework\spring-expression\5.2.6.RELEASE\spring-expression-5.2.6.RELEASE.jar;D:\localfile\apache-maven-3.5.4\repository\org\projectlombok\lombok\1.18.12\lombok-1.18.12.jar;D:\localfile\apache-maven-3.5.4\repository\org\springframework\spring-core\5.2.6.RELEASE\spring-core-5.2.6.RELEASE.jar;D:\localfile\apache-maven-3.5.4\repository\org\springframework\spring-jcl\5.2.6.RELEASE\spring-jcl-5.2.6.RELEASE.jar;D:\Program Files\JetBrains\IntelliJ IDEA 2019.1.3\lib\idea_rt.jar" com.myrepository.mytemplate.SpringFamilyClientApplication
Connected to the target VM, address: '127.0.0.1:63752', transport: 'socket'

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

2020-07-22 11:14:13.494  INFO 10956 --- [           main] c.m.m.SpringFamilyClientApplication      : Starting SpringFamilyClientApplication on WIN-3A7O8CVIB4J with PID 10956 (D:\ideaWork\spring-family-mytemplate\spring-family-client\target\classes started by win-20190221 in D:\ideaWork\spring-family-mytemplate)
2020-07-22 11:14:13.499  INFO 10956 --- [           main] c.m.m.SpringFamilyClientApplication      : The following profiles are active: dev
2020-07-22 11:14:14.461  INFO 10956 --- [           main] .s.d.r.c.RepositoryConfigurationDelegate : Multiple Spring Data modules found, entering strict repository configuration mode!
2020-07-22 11:14:14.464  INFO 10956 --- [           main] .s.d.r.c.RepositoryConfigurationDelegate : Bootstrapping Spring Data Redis repositories in DEFAULT mode.
2020-07-22 11:14:14.502  INFO 10956 --- [           main] .s.d.r.c.RepositoryConfigurationDelegate : Finished Spring Data repository scanning in 21ms. Found 0 Redis repository interfaces.
2020-07-22 11:14:14.902 ERROR 10956 --- [           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-07-22 11:14:15.076 ERROR 10956 --- [           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-07-22 11:14:15.233  INFO 10956 --- [           main] o.s.b.w.embedded.tomcat.TomcatWebServer  : Tomcat initialized with port(s): 9092 (http)
2020-07-22 11:14:15.247 ERROR 10956 --- [           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-07-22 11:14:15.247  INFO 10956 --- [           main] o.apache.catalina.core.StandardService   : Starting service [Tomcat]
2020-07-22 11:14:15.248  INFO 10956 --- [           main] org.apache.catalina.core.StandardEngine  : Starting Servlet engine: [Apache Tomcat/9.0.35]
2020-07-22 11:14:15.429  INFO 10956 --- [           main] o.a.c.c.C.[Tomcat].[localhost].[/]       : Initializing Spring embedded WebApplicationContext
2020-07-22 11:14:15.430  INFO 10956 --- [           main] o.s.web.context.ContextLoader            : Root WebApplicationContext: initialization completed in 1878 ms
2020-07-22 11:14:15.565  INFO 10956 --- [           main] c.a.d.s.b.a.DruidDataSourceAutoConfigure : Init DruidDataSource
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 SPI and manual loading of the driver class is generally unnecessary.
2020-07-22 11:14:15.793  INFO 10956 --- [           main] com.alibaba.druid.pool.DruidDataSource   : {dataSource-1} inited
 _ _   |_  _ _|_. ___ _ |    _ 
| | |\/|_)(_| | |_\  |_)||_|_\ 
     /               |         
                        3.1.0 
2020-07-22 11:14:20.777 ERROR 10956 --- [-Create-3947009] com.alibaba.druid.pool.DruidDataSource   : create connection SQLException, url: jdbc:mysql://127.0.0.1:3306/test?characterEncoding=utf-8&autoReconnect=true&failOverReadOnly=false&useSSL=true, errorCode 0, state 08001

java.sql.SQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up.
	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:110) ~[mysql-connector-java-8.0.20.jar:8.0.20]
	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97) ~[mysql-connector-java-8.0.20.jar:8.0.20]
	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:89) ~[mysql-connector-java-8.0.20.jar:8.0.20]
	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:63) ~[mysql-connector-java-8.0.20.jar:8.0.20]
	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:73) ~[mysql-connector-java-8.0.20.jar:8.0.20]
	at com.mysql.cj.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:906) ~[mysql-connector-java-8.0.20.jar:8.0.20]
	at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:831) ~[mysql-connector-java-8.0.20.jar:8.0.20]
	at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:456) ~[mysql-connector-java-8.0.20.jar:8.0.20]
	at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:246) ~[mysql-connector-java-8.0.20.jar:8.0.20]
	at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:197) ~[mysql-connector-java-8.0.20.jar:8.0.20]
	at com.alibaba.druid.filter.FilterChainImpl.connection_connect(FilterChainImpl.java:156) ~[druid-1.1.10.jar:1.1.10]
	at com.alibaba.druid.filter.stat.StatFilter.connection_connect(StatFilter.java:218) ~[druid-1.1.10.jar:1.1.10]
	at com.alibaba.druid.filter.FilterChainImpl.connection_connect(FilterChainImpl.java:150) ~[druid-1.1.10.jar:1.1.10]
	at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1560) ~[druid-1.1.10.jar:1.1.10]
	at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1623) ~[druid-1.1.10.jar:1.1.10]
	at com.alibaba.druid.pool.DruidDataSource$CreateConnectionThread.run(DruidDataSource.java:2468) ~[druid-1.1.10.jar:1.1.10]
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 specifc 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.20.jar:8.0.20]
	at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:85) ~[mysql-connector-java-8.0.20.jar:8.0.20]
	at com.mysql.cj.util.TimeUtil.getCanonicalTimezone(TimeUtil.java:132) ~[mysql-connector-java-8.0.20.jar:8.0.20]
	at com.mysql.cj.protocol.a.NativeProtocol.configureTimezone(NativeProtocol.java:2120) ~[mysql-connector-java-8.0.20.jar:8.0.20]
	at com.mysql.cj.protocol.a.NativeProtocol.initServerSession(NativeProtocol.java:2143) ~[mysql-connector-java-8.0.20.jar:8.0.20]
	at com.mysql.cj.jdbc.ConnectionImpl.initializePropsFromServer(ConnectionImpl.java:1310) ~[mysql-connector-java-8.0.20.jar:8.0.20]
	at com.mysql.cj.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:869) ~[mysql-connector-java-8.0.20.jar:8.0.20]
	... 10 common frames omitted

2020-07-22 11:14:25.790 ERROR 10956 --- [-Create-3947009] com.alibaba.druid.pool.DruidDataSource   : create connection SQLException, url: jdbc:mysql://127.0.0.1:3306/test?characterEncoding=utf-8&autoReconnect=true&failOverReadOnly=false&useSSL=true, errorCode 0, state 08001

java.sql.SQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up.
	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:110) ~[mysql-connector-java-8.0.20.jar:8.0.20]
	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97) ~[mysql-connector-java-8.0.20.jar:8.0.20]
	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:89) ~[mysql-connector-java-8.0.20.jar:8.0.20]
	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:63) ~[mysql-connector-java-8.0.20.jar:8.0.20]
	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:73) ~[mysql-connector-java-8.0.20.jar:8.0.20]
	at com.mysql.cj.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:906) ~[mysql-connector-java-8.0.20.jar:8.0.20]
	at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:831) ~[mysql-connector-java-8.0.20.jar:8.0.20]
	at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:456) ~[mysql-connector-java-8.0.20.jar:8.0.20]
	at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:246) ~[mysql-connector-java-8.0.20.jar:8.0.20]
	at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:197) ~[mysql-connector-java-8.0.20.jar:8.0.20]
	at com.alibaba.druid.filter.FilterChainImpl.connection_connect(FilterChainImpl.java:156) ~[druid-1.1.10.jar:1.1.10]
	at com.alibaba.druid.filter.stat.StatFilter.connection_connect(StatFilter.java:218) ~[druid-1.1.10.jar:1.1.10]
	at com.alibaba.druid.filter.FilterChainImpl.connection_connect(FilterChainImpl.java:150) ~[druid-1.1.10.jar:1.1.10]
	at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1560) ~[druid-1.1.10.jar:1.1.10]
	at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1623) ~[druid-1.1.10.jar:1.1.10]
	at com.alibaba.druid.pool.DruidDataSource$CreateConnectionThread.run(DruidDataSource.java:2468) ~[druid-1.1.10.jar:1.1.10]
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 specifc 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.20.jar:8.0.20]
	at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:85) ~[mysql-connector-java-8.0.20.jar:8.0.20]
	at com.mysql.cj.util.TimeUtil.getCanonicalTimezone(TimeUtil.java:132) ~[mysql-connector-java-8.0.20.jar:8.0.20]
	at com.mysql.cj.protocol.a.NativeProtocol.configureTimezone(NativeProtocol.java:2120) ~[mysql-connector-java-8.0.20.jar:8.0.20]
	at com.mysql.cj.protocol.a.NativeProtocol.initServerSession(NativeProtocol.java:2143) ~[mysql-connector-java-8.0.20.jar:8.0.20]
	at com.mysql.cj.jdbc.ConnectionImpl.initializePropsFromServer(ConnectionImpl.java:1310) ~[mysql-connector-java-8.0.20.jar:8.0.20]
	at com.mysql.cj.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:869) ~[mysql-connector-java-8.0.20.jar:8.0.20]
	... 10 common frames omitted

二：出现原因和决绝方式

①：是因为数据库链接url未加入时区
②：解决方式如下：
在这里插入图片描述

③：启动无异常（完美解决）

D:\localfile\jdk-8u172-windows-i586\bin\java.exe -agentlib:jdwp=transport=dt_socket,address=127.0.0.1:64053,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\spring-family-mytemplate\spring-family-client\target\classes;D:\ideaWork\spring-family-mytemplate\spring-family-common\target\classes;D:\localfile\apache-maven-3.5.4\repository\org\springframework\boot\spring-boot-starter-data-redis\2.3.0.RELEASE\spring-boot-starter-data-redis-2.3.0.RELEASE.jar;D:\localfile\apache-maven-3.5.4\repository\org\springframework\data\spring-data-redis\2.3.0.RELEASE\spring-data-redis-2.3.0.RELEASE.jar;D:\localfile\apache-maven-3.5.4\repository\org\springframework\data\spring-data-keyvalue\2.3.0.RELEASE\spring-data-keyvalue-2.3.0.RELEASE.jar;D:\localfile\apache-maven-3.5.4\repository\org\springframework\data\spring-data-commons\2.3.0.RELEASE\spring-data-commons-2.3.0.RELEASE.jar;D:\localfile\apache-maven-3.5.4\repository\org\springframework\spring-tx\5.2.6.RELEASE\spring-tx-5.2.6.RELEASE.jar;D:\localfile\apache-maven-3.5.4\repository\org\springframework\spring-oxm\5.2.6.RELEASE\spring-oxm-5.2.6.RELEASE.jar;D:\localfile\apache-maven-3.5.4\repository\org\springframework\spring-context-support\5.2.6.RELEASE\spring-context-support-5.2.6.RELEASE.jar;D:\localfile\apache-maven-3.5.4\repository\io\lettuce\lettuce-core\5.3.0.RELEASE\lettuce-core-5.3.0.RELEASE.jar;D:\localfile\apache-maven-3.5.4\repository\io\netty\netty-common\4.1.49.Final\netty-common-4.1.49.Final.jar;D:\localfile\apache-maven-3.5.4\repository\io\netty\netty-handler\4.1.49.Final\netty-handler-4.1.49.Final.jar;D:\localfile\apache-maven-3.5.4\repository\io\netty\netty-resolver\4.1.49.Final\netty-resolver-4.1.49.Final.jar;D:\localfile\apache-maven-3.5.4\repository\io\netty\netty-buffer\4.1.49.Final\netty-buffer-4.1.49.Final.jar;D:\localfile\apache-maven-3.5.4\repository\io\netty\netty-codec\4.1.49.Final\netty-codec-4.1.49.Final.jar;D:\localfile\apache-maven-3.5.4\repository\io\netty\netty-transport\4.1.49.Final\netty-transport-4.1.49.Final.jar;D:\localfile\apache-maven-3.5.4\repository\io\projectreactor\reactor-core\3.3.5.RELEASE\reactor-core-3.3.5.RELEASE.jar;D:\localfile\apache-maven-3.5.4\repository\org\reactivestreams\reactive-streams\1.0.3\reactive-streams-1.0.3.jar;D:\localfile\apache-maven-3.5.4\repository\mysql\mysql-connector-java\8.0.20\mysql-connector-java-8.0.20.jar;D:\localfile\apache-maven-3.5.4\repository\com\alibaba\druid-spring-boot-starter\1.1.10\druid-spring-boot-starter-1.1.10.jar;D:\localfile\apache-maven-3.5.4\repository\com\alibaba\druid\1.1.10\druid-1.1.10.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\boot\spring-boot-autoconfigure\2.3.0.RELEASE\spring-boot-autoconfigure-2.3.0.RELEASE.jar;D:\localfile\apache-maven-3.5.4\repository\com\baomidou\mybatis-plus-boot-starter\3.1.0\mybatis-plus-boot-starter-3.1.0.jar;D:\localfile\apache-maven-3.5.4\repository\com\baomidou\mybatis-plus\3.1.0\mybatis-plus-3.1.0.jar;D:\localfile\apache-maven-3.5.4\repository\org\springframework\boot\spring-boot-starter-jdbc\2.3.0.RELEASE\spring-boot-starter-jdbc-2.3.0.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.6.RELEASE\spring-jdbc-5.2.6.RELEASE.jar;D:\localfile\apache-maven-3.5.4\repository\com\baomidou\mybatis-plus-generator\3.1.0\mybatis-plus-generator-3.1.0.jar;D:\localfile\apache-maven-3.5.4\repository\com\baomidou\mybatis-plus-extension\3.1.0\mybatis-plus-extension-3.1.0.jar;D:\localfile\apache-maven-3.5.4\repository\com\baomidou\mybatis-plus-core\3.1.0\mybatis-plus-core-3.1.0.jar;D:\localfile\apache-maven-3.5.4\repository\com\baomidou\mybatis-plus-annotation\3.1.0\mybatis-plus-annotation-3.1.0.jar;D:\localfile\apache-maven-3.5.4\repository\org\mybatis\mybatis\3.5.0\mybatis-3.5.0.jar;D:\localfile\apache-maven-3.5.4\repository\com\github\jsqlparser\jsqlparser\1.4\jsqlparser-1.4.jar;D:\localfile\apache-maven-3.5.4\repository\org\mybatis\mybatis-spring\2.0.0\mybatis-spring-2.0.0.jar;D:\localfile\apache-maven-3.5.4\repository\org\freemarker\freemarker\2.3.30\freemarker-2.3.30.jar;D:\localfile\apache-maven-3.5.4\repository\org\springframework\boot\spring-boot-starter-web\2.3.0.RELEASE\spring-boot-starter-web-2.3.0.RELEASE.jar;D:\localfile\apache-maven-3.5.4\repository\org\springframework\boot\spring-boot-starter\2.3.0.RELEASE\spring-boot-starter-2.3.0.RELEASE.jar;D:\localfile\apache-maven-3.5.4\repository\org\springframework\boot\spring-boot\2.3.0.RELEASE\spring-boot-2.3.0.RELEASE.jar;D:\localfile\apache-maven-3.5.4\repository\org\springframework\boot\spring-boot-starter-logging\2.3.0.RELEASE\spring-boot-starter-logging-2.3.0.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.2\log4j-to-slf4j-2.13.2.jar;D:\localfile\apache-maven-3.5.4\repository\org\apache\logging\log4j\log4j-api\2.13.2\log4j-api-2.13.2.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.0.RELEASE\spring-boot-starter-json-2.3.0.RELEASE.jar;D:\localfile\apache-maven-3.5.4\repository\com\fasterxml\jackson\core\jackson-databind\2.11.0\jackson-databind-2.11.0.jar;D:\localfile\apache-maven-3.5.4\repository\com\fasterxml\jackson\core\jackson-annotations\2.11.0\jackson-annotations-2.11.0.jar;D:\localfile\apache-maven-3.5.4\repository\com\fasterxml\jackson\core\jackson-core\2.11.0\jackson-core-2.11.0.jar;D:\localfile\apache-maven-3.5.4\repository\com\fasterxml\jackson\datatype\jackson-datatype-jdk8\2.11.0\jackson-datatype-jdk8-2.11.0.jar;D:\localfile\apache-maven-3.5.4\repository\com\fasterxml\jackson\datatype\jackson-datatype-jsr310\2.11.0\jackson-datatype-jsr310-2.11.0.jar;D:\localfile\apache-maven-3.5.4\repository\com\fasterxml\jackson\module\jackson-module-parameter-names\2.11.0\jackson-module-parameter-names-2.11.0.jar;D:\localfile\apache-maven-3.5.4\repository\org\springframework\boot\spring-boot-starter-tomcat\2.3.0.RELEASE\spring-boot-starter-tomcat-2.3.0.RELEASE.jar;D:\localfile\apache-maven-3.5.4\repository\org\apache\tomcat\embed\tomcat-embed-core\9.0.35\tomcat-embed-core-9.0.35.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.35\tomcat-embed-websocket-9.0.35.jar;D:\localfile\apache-maven-3.5.4\repository\org\springframework\spring-web\5.2.6.RELEASE\spring-web-5.2.6.RELEASE.jar;D:\localfile\apache-maven-3.5.4\repository\org\springframework\spring-beans\5.2.6.RELEASE\spring-beans-5.2.6.RELEASE.jar;D:\localfile\apache-maven-3.5.4\repository\org\springframework\spring-webmvc\5.2.6.RELEASE\spring-webmvc-5.2.6.RELEASE.jar;D:\localfile\apache-maven-3.5.4\repository\org\springframework\spring-aop\5.2.6.RELEASE\spring-aop-5.2.6.RELEASE.jar;D:\localfile\apache-maven-3.5.4\repository\org\springframework\spring-context\5.2.6.RELEASE\spring-context-5.2.6.RELEASE.jar;D:\localfile\apache-maven-3.5.4\repository\org\springframework\spring-expression\5.2.6.RELEASE\spring-expression-5.2.6.RELEASE.jar;D:\localfile\apache-maven-3.5.4\repository\org\projectlombok\lombok\1.18.12\lombok-1.18.12.jar;D:\localfile\apache-maven-3.5.4\repository\org\springframework\spring-core\5.2.6.RELEASE\spring-core-5.2.6.RELEASE.jar;D:\localfile\apache-maven-3.5.4\repository\org\springframework\spring-jcl\5.2.6.RELEASE\spring-jcl-5.2.6.RELEASE.jar;D:\Program Files\JetBrains\IntelliJ IDEA 2019.1.3\lib\idea_rt.jar" com.myrepository.mytemplate.SpringFamilyClientApplication
Connected to the target VM, address: '127.0.0.1:64053', transport: 'socket'

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

2020-07-22 11:16:41.455  INFO 6312 --- [           main] c.m.m.SpringFamilyClientApplication      : Starting SpringFamilyClientApplication on WIN-3A7O8CVIB4J with PID 6312 (D:\ideaWork\spring-family-mytemplate\spring-family-client\target\classes started by win-20190221 in D:\ideaWork\spring-family-mytemplate)
2020-07-22 11:16:41.457  INFO 6312 --- [           main] c.m.m.SpringFamilyClientApplication      : The following profiles are active: dev
2020-07-22 11:16:42.143  INFO 6312 --- [           main] .s.d.r.c.RepositoryConfigurationDelegate : Multiple Spring Data modules found, entering strict repository configuration mode!
2020-07-22 11:16:42.147  INFO 6312 --- [           main] .s.d.r.c.RepositoryConfigurationDelegate : Bootstrapping Spring Data Redis repositories in DEFAULT mode.
2020-07-22 11:16:42.174  INFO 6312 --- [           main] .s.d.r.c.RepositoryConfigurationDelegate : Finished Spring Data repository scanning in 19ms. Found 0 Redis repository interfaces.
2020-07-22 11:16:42.435 ERROR 6312 --- [           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-07-22 11:16:42.544 ERROR 6312 --- [           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-07-22 11:16:42.617  INFO 6312 --- [           main] o.s.b.w.embedded.tomcat.TomcatWebServer  : Tomcat initialized with port(s): 9092 (http)
2020-07-22 11:16:42.623 ERROR 6312 --- [           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-07-22 11:16:42.624  INFO 6312 --- [           main] o.apache.catalina.core.StandardService   : Starting service [Tomcat]
2020-07-22 11:16:42.624  INFO 6312 --- [           main] org.apache.catalina.core.StandardEngine  : Starting Servlet engine: [Apache Tomcat/9.0.35]
2020-07-22 11:16:42.741  INFO 6312 --- [           main] o.a.c.c.C.[Tomcat].[localhost].[/]       : Initializing Spring embedded WebApplicationContext
2020-07-22 11:16:42.742  INFO 6312 --- [           main] o.s.web.context.ContextLoader            : Root WebApplicationContext: initialization completed in 1247 ms
2020-07-22 11:16:42.832  INFO 6312 --- [           main] c.a.d.s.b.a.DruidDataSourceAutoConfigure : Init DruidDataSource
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 SPI and manual loading of the driver class is generally unnecessary.
2020-07-22 11:16:42.938  INFO 6312 --- [           main] com.alibaba.druid.pool.DruidDataSource   : {dataSource-1} inited
 _ _   |_  _ _|_. ___ _ |    _ 
| | |\/|_)(_| | |_\  |_)||_|_\ 
     /               |         
                        3.1.0 
2020-07-22 11:16:43.462  INFO 6312 --- [           main] o.s.s.concurrent.ThreadPoolTaskExecutor  : Initializing ExecutorService 'applicationTaskExecutor'
2020-07-22 11:16:44.036  INFO 6312 --- [           main] o.s.b.w.embedded.tomcat.TomcatWebServer  : Tomcat started on port(s): 9092 (http) with context path ''
2020-07-22 11:16:44.042  INFO 6312 --- [           main] c.m.m.SpringFamilyClientApplication      : Started SpringFamilyClientApplication in 3.951 seconds (JVM running for 4.634)
码农巅峰
关注
  • 1
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
IDEA链接MySQL报错08001和连接成功后不显示表的问题及解决方法
01-19
[08001] Could not create connection to database server. Attempted reconnect 3 times. Giving up. 解决办法：在url后面拼接?serverTimezone=UTC 连接成功后数据库不显示表 通过设置解决： scheme选择当前...
SVN出现提示org.apache.subversion.javahl.ClientException: Attempted to lock an already-locked dir解决方案
09-01
主要介绍了SVN出现提示org.apache.subversion.javahl.ClientException: Attempted to lock an already-locked dir解决方案的相关资料,需要的朋友可以参考下
springboot启动连接mysql报错Could not create connection to database server. Attempted reconnect 3 times. Gi
Mint6的博客
07-12 4894
1.错误场景：错误提示如下 Could not create connection to database server. Attempted reconnect 3 times. Giving up. 2.分析原因 这个报错是连不上mysql，这里不考虑mysql权限限制不让远程访问的情况，剩下的百分之八十是设置mysql数据库连接加的参数不对。 3.解决方法 设置mysql连接参数如下，直接拷贝下面所有参数，来解决问题： jdbc:mysql://127.0.0.1:3306/base?
关于springboot的Could not create connection to database server. Attempted reconnect 3 times. 启动报错问题
wsdssb521的博客
09-09 3204
首先贴图，报错信息： w 网上查询了，首先都是说需要在数据库连接上添加时区，serverTimezone=GMT。但其实这个问题首先需要考虑的是，版本问题，就是你的mysql-connector-java版本是否过高，如果你的springboot版本为2.3.3那么这个默认的版本就是8.0.21，所以首先确定这个，跟你的mysql，是否匹配，调整这个版本，之后还有问题，再试试时区的问题，查看版本可在如下图 当我，添加了版本信息后，就不出现这个报错了。 ...
已解决java.sql.SQLNonTransientConnectionException: SQL非瞬态连接异常的正确解决方法，亲测有效！！！
最新发布
小明的Java问道之路
04-18 1078
已解决java.sql.SQLNonTransientConnectionException: SQL非瞬态连接异常的正确解决方法，亲测有效！！！
【SQL】【Springboot】Could not create connection to database server.
韩旭051的博客
05-24 886
mysqll版本号和maven中pom文件中配置的mysql-connector版本号不同，在将pom文件中的版本号改成本地mysql的版本号以后再更新maven问题解决。 小tips: 1.如何知道自己的mysql版本号： 在任何一个能执行sql语句的地方执行语句：select version() from dual; 它就会返回一个版本号 2.如果这个方法不好使，可以试试将mysql驱动名改成：com.mysql.cj.jdbc.Driver 实验楼的教程中 使用的spring.datasou.
SpringBoots连接数据库报错Could not create connection to database server. Attempted reconnect 3 times. Givin
FYANGFEI的博客
04-04 309
解决方法 jdbcUrl换成这个 jdbc:mysql://localhost:3306/goods?useUnicode=true&characterEncoding=UTF-8&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&serverTimezone=UTC ...
Springboot连接MySQL报出Could not create connection to database server错误
weixin_46825091的博客
04-06 455
Springboot连接MySQL报出Could not create connection to database server错误 项目场景： 初学spring boot连接mysql，进行增删改查操作 问题描述： 在pom.xml文件导入依赖 <dependency> <groupId>mysql</groupId> <artifactId>mysql-connector-java</
树莓派4B无法启动，出现end kernel panic not syncing: attempted to kill init! exitcode = 0x00000000b
01-06
本人最近在玩树莓派4B的时候，树莓派在烧录镜像之后，无法启动，一直卡死在end kernel panic not syncing: attempted to kill init! exitcode = 0x00000000b 环境 设备：树莓派4B 查找原因–树莓派官网 根据官网给...
ns3 assert failed. cond=”uid != 0″, msg=”Assert in TypeId::LookupByName: xxx not found”, file=../src
01-20
ns3中在使用.waf –run xxx时候出现 assert failed. cond=”uid != 0″, msg=”Assert in TypeId::LookupByName: sender not found”, file=../src/core/model/type-id.cc, line=828 terminate called without an ...
虚拟机黑屏end kernel panic - not syncing两种解决方式.docx
01-06
虚拟机黑屏end kernel panic - not syncing两种解决方式 ...end kernel panic - not syncing: Attempted to kill init! exit code=0x0000000b 创建新的兼容性虚拟机或该 vmx文件都可以修复问题。
spring boot项目启动报错：Could not create connection to database server
路西法Lucifer
12-18 4703
 问题：          今天启动spring boot的项目，突然报了如下错误： 2018-12-18 21:17:20.182 ERROR 16688 --- [reate-682025329] com.alibaba.druid.pool.DruidDataSource : create connection error, url: jdbc:mysql://192.168.16...
Could not create connection to database server. Attempted reconnect 3 times. Giving up.
热门推荐
u011250186的博客
12-13 1万+
Could not create connection to database server. Attempted reconnect 3 times. Giving up.
Could not create connection to database server. Attempted reconnect 3 times. Giving up
m0_56649994的博客
10-13 2628
如果你的项目是从别人那拉取过来的，别人的项目都能正常启动，自己的项目一启动就报错，就试试我的方法。
Attempted reconnect 3 times. Giving up
samuBO的博客
04-12 9505
tomcat启动时报错： Could not create connection to database server. Attempted reconnect 3 times. Giving up 原因： mysql驱动包和我的mysql版本不配 我的驱动包是5.1.47 ,数据库为MySQL5.7 解决： 升级jar包 <dependency> <groupId&...
Could not create connection to database server. Attempted reconnect 3 times. Giving up.（JDBC连接MYSQL）
ke_new的博客
07-02 1717
写个JDBC连接Mysql数据库，配置什么的都没有问题居然报了个这样的错误，百度翻译：无法创建到数据库服务器的连接。尝试重新连接3次。放弃 Could not create connection to database server. Attempted reconnect 3 times. Giving up. 首先检查自己的mysql驱动版本，是否对应自己的mysql安装版本。后来查阅资料发现是时区设置不正确。 解决办法：在jdbc连接的url后面加上serverTimezone=GMT ...
「Issue-001」 Could not create connection to database server. Attempted reconnect 3 times. Giving up
泛舟煮酒
12-25 946
问题状态 暂时处理 环境 IDEA, DataGrip, Mysql 8.0.12 问题描述 数据库连接配置 driver-class-name: com.mysql.jdbc.Driver url: jdbc:mysql://localhost:3306/ofit?autoReconnect=true&amp;useSSL=false username: root password: **...
idea的springboot项目Could not create connection to database server. Attempted reconnect 3 times. Giving up.
04-14
根据提供的引用内容，当在IntelliJ Idea 2020.3中导入Maven项目并运行时，可能会遇到"Could not create connection to database server. Attempted reconnect 3 times. Giving up."的错误。解决这个问题的方法是在数据库配置后面加上"serverTimezone=GMT"参数[^1]。具体步骤如下： 1. 打开项目中的Application.yml文件。 2. 在数据库配置的URL后面添加"serverTimezone=GMT"参数。 例如：url: jdbc:mysql://localhost:3306/abc?serverTimezone=GMT 3. 保存文件并重新运行项目。 这样做可以解决"Could not create connection to database server. Attempted reconnect 3 times. Giving up."的错误。

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值