Could not create connection to database server. Attempted reconnect 3 times. Giving up.

已于 2022-06-22 14:50:20 修改
阅读量2.3w 收藏 31
点赞数 43
分类专栏： spring boot 文章标签： mysql sql
于 2021-03-24 23:44:46 首次发布
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/hwxjava/article/details/115190524
版权
本文主要介绍了在使用SpringBoot连接MySQL数据库时遇到的时区异常问题，错误表现为无法创建到数据库服务器的连接。解决方案是在数据库URL中添加`&serverTimezone=Asia/Shanghai`来指定时区，或者检查并更新MySQL驱动版本和配置。同时，也提到了因使用过期驱动导致的问题，如需解决需将`driver-class-name`改为`com.mysql.cj.jdbc.Driver`。

摘要生成于 C知道 ，由 DeepSeek-R1 满血版支持， 前往体验 >

  • 报数据库连接错误
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.18.jar:8.0.18]
	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97) ~[mysql-connector-java-8.0.18.jar:8.0.18]
	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:89) ~[mysql-connector-java-8.0.18.jar:8.0.18]
	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:63) ~[mysql-connector-java-8.0.18.jar:8.0.18]
	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:73) ~[mysql-connector-java-8.0.18.jar:8.0.18]
	at com.mysql.cj.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:906) ~[mysql-connector-java-8.0.18.jar:8.0.18]
	at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:831) ~[mysql-connector-java-8.0.18.jar:8.0.18]
	at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:456) ~[mysql-connector-java-8.0.18.jar:8.0.18]
	at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:246) ~[mysql-connector-java-8.0.18.jar:8.0.18]
	at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:199) ~[mysql-connector-java-8.0.18.jar:8.0.18]
	at com.alibaba.druid.filter.FilterChainImpl.connection_connect(FilterChainImpl.java:149) ~[druid-1.1.9.jar:1.1.9]
	at com.alibaba.druid.filter.stat.StatFilter.connection_connect(StatFilter.java:218) ~[druid-1.1.9.jar:1.1.9]
	at com.alibaba.druid.filter.FilterChainImpl.connection_connect(FilterChainImpl.java:143) ~[druid-1.1.9.jar:1.1.9]
	at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1515) ~[druid-1.1.9.jar:1.1.9]
	at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1578) ~[druid-1.1.9.jar:1.1.9]
	at com.alibaba.druid.pool.DruidDataSource$CreateConnectionThread.run(DruidDataSource.java:2466) [druid-1.1.9.jar:1.1.9]
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 jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[?:?]
	at jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) ~[?:?]
	at jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[?:?]
	at java.lang.reflect.Constructor.newInstanceWithCaller(Constructor.java:500) ~[?:?]
	at java.lang.reflect.Constructor.newInstance(Constructor.java:481) ~[?:?]
	at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:61) ~[mysql-connector-java-8.0.18.jar:8.0.18]
	at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:85) ~[mysql-connector-java-8.0.18.jar:8.0.18]
	at com.mysql.cj.util.TimeUtil.getCanonicalTimezone(TimeUtil.java:132) ~[mysql-connector-java-8.0.18.jar:8.0.18]
	at com.mysql.cj.protocol.a.NativeProtocol.configureTimezone(NativeProtocol.java:2121) ~[mysql-connector-java-8.0.18.jar:8.0.18]
	at com.mysql.cj.protocol.a.NativeProtocol.initServerSession(NativeProtocol.java:2145) ~[mysql-connector-java-8.0.18.jar:8.0.18]
	at com.mysql.cj.jdbc.ConnectionImpl.initializePropsFromServer(ConnectionImpl.java:1310) ~[mysql-connector-java-8.0.18.jar:8.0.18]
	at com.mysql.cj.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:869) ~[mysql-connector-java-8.0.18.jar:8.0.18]
	... 10 more
 2021-03-24 23:11:34.692 ERROR 7744 --- [eate-1149892111] c.a.d.p.DruidDataSource                  : create connection SQLException, url: jdbc:mysql://localhost:3306/db-mcms-open?useUnicode=true&characterEncoding=utf-8&zeroDateTimeBehavior=convertToNull&autoReconnect=true&allowMultiQueries=true&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.18.jar:8.0.18]
	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97) ~[mysql-connector-java-8.0.18.jar:8.0.18]
	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:89) ~[mysql-connector-java-8.0.18.jar:8.0.18]
	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:63) ~[mysql-connector-java-8.0.18.jar:8.0.18]
	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:73) ~[mysql-connector-java-8.0.18.jar:8.0.18]
	at com.mysql.cj.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:906) ~[mysql-connector-java-8.0.18.jar:8.0.18]
	at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:831) ~[mysql-connector-java-8.0.18.jar:8.0.18]
	at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:456) ~[mysql-connector-java-8.0.18.jar:8.0.18]
	at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:246) ~[mysql-connector-java-8.0.18.jar:8.0.18]
	at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:199) ~[mysql-connector-java-8.0.18.jar:8.0.18]
	at com.alibaba.druid.filter.FilterChainImpl.connection_connect(FilterChainImpl.java:149) ~[druid-1.1.9.jar:1.1.9]
	at com.alibaba.druid.filter.stat.StatFilter.connection_connect(StatFilter.java:218) ~[druid-1.1.9.jar:1.1.9]
	at com.alibaba.druid.filter.FilterChainImpl.connection_connect(FilterChainImpl.java:143) ~[druid-1.1.9.jar:1.1.9]
	at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1515) ~[druid-1.1.9.jar:1.1.9]
	at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1578) ~[druid-1.1.9.jar:1.1.9]
	at com.alibaba.druid.pool.DruidDataSource$CreateConnectionThread.run(DruidDataSource.java:2466) [druid-1.1.9.jar:1.1.9]
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 jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[?:?]
	at jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) ~[?:?]
	at jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[?:?]
	at java.lang.reflect.Constructor.newInstanceWithCaller(Constructor.java:500) ~[?:?]
	at java.lang.reflect.Constructor.newInstance(Constructor.java:481) ~[?:?]
	at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:61) ~[mysql-connector-java-8.0.18.jar:8.0.18]
	at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:85) ~[mysql-connector-java-8.0.18.jar:8.0.18]
	at com.mysql.cj.util.TimeUtil.getCanonicalTimezone(TimeUtil.java:132) ~[mysql-connector-java-8.0.18.jar:8.0.18]
	at com.mysql.cj.protocol.a.NativeProtocol.configureTimezone(NativeProtocol.java:2121) ~[mysql-connector-java-8.0.18.jar:8.0.18]
	at com.mysql.cj.protocol.a.NativeProtocol.initServerSession(NativeProtocol.java:2145) ~[mysql-connector-java-8.0.18.jar:8.0.18]
	at com.mysql.cj.jdbc.ConnectionImpl.initializePropsFromServer(ConnectionImpl.java:1310) ~[mysql-connector-java-8.0.18.jar:8.0.18]
	at com.mysql.cj.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:869) ~[mysql-connector-java-8.0.18.jar:8.0.18]
	... 10 more

  1. 错误
    create connection SQLException
    创建连接数据库发生了意外
    错误原因：
    Could not create connection to database server. Attempted reconnect 3 times. Giving up.
    无法创建到数据库服务器的连接。尝试重新连接3次。放弃。

  2. 原因

1

***springboot 2.0（包括高版本的jdk）如果不配置这个会报时区错误；我这里指定的是亚洲上海的区时
3. 解决办法
指定区时
url中加入 &serverTimezone=UTC
（选择UTC会比中国早8个小时，如果在中国可以选择
Asia/Shanghai或者Asia/Hongkong ）

  url: jdbc:mysql://localhost:3306/db-mcms-open?useUnicode=true&characterEncoding=utf-8&zeroDateTimeBehavior=convertToNull&autoReconnect=true&allowMultiQueries=true&useSSL=true&serverTimezone=Asia/Shanghai

2

MySQL数据库未开启导致报错 ，启动MySQL数据库即解决
即解决
2021.3.21号错误

3

MySQL数据库版本和导入的jar包差异过大，由于每个人原因可能不一样，本人的mysql数据库为
8.0.21,但是导入的是5.1.47的jar包，导致报错，修改导入的依赖版本之后，还是报错
原因

driver-class-name: org.gjt.mm.mysql.Driver

应该将其改为

driver-class-name: com.mysql.cj.jdbc.Driver

问题即解决

Springboot：Could not create connection to database server. Attempted reconnect 3 times. Giving up.
马句
12-03 4535
改造了一个老项目在配置数据的时候出现了这个提示 问题应该是mysql-connector-java 中的jar版本太高，与自己的mysql版本不符 看了下我的mysql版本是5.7的 pom里面原来是这么配置的 <dependency> <groupId>mysql</groupId> <artifactId>mysql-connector-java</artifactId> <scope>runtime&l
【Nacos】Nacos MySQL 配置 启动报错 ould not create connection to database server. Attempted reconnect 3 time
九师兄
04-04 5597
在章节：【SpringCloud】Spring cloud Alibaba Nacos 集群和持久化配置 中设置MySQL，但是没有启动成功。配置如下 报错如下 而我确信能连接成功 找了一圈，最后怀疑是版本问题。我目前版本是8.x 然后根据这篇文章：Docer安装MySQL并且远程登录 安装了 ，因为在博客 nacos1.1.4 配置mysql 替换内嵌的cmdb ，添加自定义nacos控制台登录用户账号密码 安装数据库，版本要求：查看默认的版本连接 重新搞了2个都没解决 本文出自 csdn 九师兄，防
spring cloud项目连接MySQL数据库报错：[08001] Could not create connection to database server. Attempted reconne
最新发布
weixin_60215299的博客
03-20 345
本文解决了IDEA在连接MYSQL数据库时项目的连接池不一致，导致连不上的问题
Could not create connection to database server.Attempted reconnect 3 times .Giving up 解决
CrazyFlyingBee的博客
02-03 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.
weixin_75001968的博客
05-10 2487
不用怀疑，就是数据库连接配置有问题，使用dbms检查一下数据库连接是否成功，不成功就检查jdbc的连接信息是不是写错了，数据库ip呀，用户名密码呀，数据库名称呀；成功就说明项目里的properties或者yaml配置文件写错了，某个字母输错了比如database写成datebase之类的。
Could not create connection to database server.Attempted reconnect 3 times. Giving up.
日常笔记 | 干货分享 | 毕设源码 | 毕设指导 | 答辩指导
11-01 5240
Connection to @localhost failed. [08001] Could not create connection to database server. Attempted reconnect 3 times. Giving up. 在连接字符串后面加上?serverTimezone=UTC 其中UTC是统一标准世界时间。 添加这个时区后 Cannot connect to a database （不能连接到数据库） Step 1. Check your network se
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."的错误。解决这个问题的方法是在...
ava.sql.SQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up.
11-03
这个错误信息"Ava.sql.SQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up."通常是在尝试连接MySQL数据库时发生的。它表示应用程序试图...
数据库5.2.6Could not create connection to database server. Attempted reconnect 3 times. Giving up.
04-30
数据库错误信息"5.2.6 Could not create connection to database server. Attempted reconnect 3 times. Giving up."表示无法创建与数据库服务器的连接，并尝试重新连接了3次后放弃了。这个错误通常出现在以下几种...
nacos Could not create connection to database server. Attempted reconnect 3 times. Giving up.
03-02
当出现"Could not create connection to database server. Attempted reconnect 3 times. Giving up."的错误时，通常是由于nacos无法连接到数据库服务器导致的。 这个错误可能有以下几个原因： 1. 数据库服务器未...
08001] Could not create connection to database server. Attempted reconnect 3 times.
u011250186的博客
12-13 1万+
https://blog.csdn.net/Roker_966/article/details/105038178
数据库连接失败: Could not create connection to database server. Attempted reconnect 3 times. Giving up.
向明天的美好出发
09-28 1万+
mysql 连接失败
Could not create connection to database server. Attempted reconnect 3 times. Giving up
m0_56649994的博客
10-13 3949
如果你的项目是从别人那拉取过来的，别人的项目都能正常启动，自己的项目一启动就报错，就试试我的方法。
解决异常：Could not create connection to database server. Attempted reconnect 3 times.
weixin_44961626的博客
07-15 2万+
解决异常：Could not create connection to database server. Attempted reconnect 3 times. 安装MySQL以后，使用IDEA2019连接MySQL出现如下错误，刚开始我以为是连接MySQL的配置文件参数写错了，检查以后发现都是正确的，于是仔细看了一下报的错误，感觉应该是MySQL监听器出现了问题 试了试连接用Navicat...
IDEA远程连接mysql数据库错误： Could not create connection to database server. Attempted reconnect 3 times. Giv
m0_46116315的博客
02-26 2453
IDEA远程连接mysql数据库错误： Could not create connection to database server. Attempted reconnect 3 times. Giving up.【解决办法】
Mysql连接时报错“Could not create connection to database server. Attempted reconnect 3 times.”
热门推荐
终码一生
08-28 10万+
Mysql连接时报错“Could not create connection to database server. Attempted reconnect 3 times.” 今天搭建完项目，打算写一个简单的写入数据库的程序，没想到因为这个问题直接卡了好一会。 报错如下： com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create connection to database se.
评论 5
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包

打赏作者

爷可是个天才

你的鼓励将是我创作的最大动力

¥1 ¥2 ¥4 ¥6 ¥10 ¥20
扫码支付：¥1
获取中
扫码支付

您的余额不足，请更换扫码支付或充值

打赏作者

实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

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

余额充值