Maven项目中：com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create conn

红太狼 2023-10-18 13:54 16阅读 0赞

## 报错信息 ##

![Image 1][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0JBREFPX0xJVU1BTkdfUUlaSEk_size_16_color_FFFFFF_t_70][]

## 详细信息 ##

ERROR [Druid-ConnectionPool-Create-2074541388] - create connection error, url:
    
    jdbc:mysql://localhost:3306/ssmtest?characterEncoding=UTF-8, errorCode 0, state 08001
    com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create
    
    connection to database server.
     at sun.reflect.GeneratedConstructorAccessor21.newInstance(Unknown Source)
     at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
     at java.lang.reflect.Constructor.newInstance(Unknown Source)
     at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
     at com.mysql.jdbc.Util.getInstance(Util.java:386)
     at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1015)
     at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:989)
     at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:975)
     at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:920)
     at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2568)
     at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2304)
     at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:834)
     at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
     at sun.reflect.GeneratedConstructorAccessor18.newInstance(Unknown Source)
     at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
     at java.lang.reflect.Constructor.newInstance(Unknown Source)
     at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
     at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:416)
     at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:346)
     at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection
    
    (DruidAbstractDataSource.java:1408)
     at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection
    
    (DruidAbstractDataSource.java:1464)
     at com.alibaba.druid.pool.DruidDataSource$CreateConnectionThread.run
    
    (DruidDataSource.java:1995)
    Caused by: java.lang.NullPointerException
     at com.mysql.jdbc.ConnectionImpl.getServerCharacterEncoding(ConnectionImpl.java:3279)
     at com.mysql.jdbc.MysqlIO.sendConnectionAttributes(MysqlIO.java:1940)
     at com.mysql.jdbc.MysqlIO.proceedHandshakeWithPluggableAuthentication(MysqlIO.java:1866)
     at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1252)
     at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2486)
     at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2519)
     ... 12 more

## 解决 ##

这是因为本地的mysql安装的8.0，而项目所使用的驱动是5.1。

### 怎样确认？ ###

首先查看本地mysql版本以及安装路径

打开桌面左下角搜索，输入mysql，找到mysql \*.\* Command Line Client,这里是mysql 8.0 Command Line Client，

可见是安装的mysql8.0

点击后输入密码再输入:

show variables like "%char%";

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0JBREFPX0xJVU1BTkdfUUlaSEk_size_16_color_FFFFFF_t_70 1][]

打开Maven项目目录下的pom.xml,找到mysql的驱动依赖

原来是5.1.26的版本，现在将其改为8.0.11

![Image 1][]![20190119162633800.jpg][]

为什么是8.0.11

到maven的中央仓库中可以看到没有版本8.0.0

![Image 1][]![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0JBREFPX0xJVU1BTkdfUUlaSEk_size_16_color_FFFFFF_t_70 2][]

将pom.xml改过来之后，重启服务器即可。

[Image 1]: 
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0JBREFPX0xJVU1BTkdfUUlaSEk_size_16_color_FFFFFF_t_70]: https://img-blog.csdnimg.cn/20190119162535746.jpg?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0JBREFPX0xJVU1BTkdfUUlaSEk=,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0JBREFPX0xJVU1BTkdfUUlaSEk_size_16_color_FFFFFF_t_70 1]: https://img-blog.csdnimg.cn/20190119162618540.jpg?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0JBREFPX0xJVU1BTkdfUUlaSEk=,size_16,color_FFFFFF,t_70
[20190119162633800.jpg]: https://img-blog.csdnimg.cn/20190119162633800.jpg
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0JBREFPX0xJVU1BTkdfUUlaSEk_size_16_color_FFFFFF_t_70 2]: https://img-blog.csdnimg.cn/2019011916263923.jpg?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0JBREFPX0xJVU1BTkdfUUlaSEk=,size_16,color_FFFFFF,t_70

Maven项目中：com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create conn

发表评论取消回复

还没有评论，来说两句吧...

相关阅读

相关 MySQLNonTransientConnectionException: Could not create connection to database server.

相关 Maven项目中：com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create conn

相关针对mysql8.0报错：com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create

相关【数据库连接异常】MySQLNonTransientConnectionException: Could not create connection to database server.

相关 com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create connection to

相关 Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create的问题解决

相关 com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create connection to

相关数据库驱动问题：MySQLNonTransientConnectionException: Could not create connection to database server

相关 Could not create JarEntryRevision

相关 MySQLNonTransientConnectionException: Could not create connection to database server.