Could not create connection to database server.亲测有效

最新推荐文章于 2024-05-10 00:08:30 发布

原创最新推荐文章于 2024-05-10 00:08:30 发布 · 2.1k 阅读

4 ·

CC 4.0 BY-SA版权

文章标签：

#mysql #java #eclipse #jdbc

本文详细解析了在使用JDBC连接MySQL数据库时遇到的“Could not create connection to database server”异常，并提供了完整的解决方案，包括调整JDBC驱动版本、更改驱动类名及URL参数，以确保与MySQL服务器版本匹配。

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

com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create connection to database server.
   at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
   at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
   at java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
   at java.base/java.lang.reflect.Constructor.newInstance(Constructor.java:490)
   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:2565)
   at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2301)
   at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:834)
   at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
   at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
   at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
   at java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
   at java.base/java.lang.reflect.Constructor.newInstance(Constructor.java:490)
   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 java.sql/java.sql.DriverManager.getConnection(DriverManager.java:677)
   at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:228)
   at testCon.main(testCon.java:25)

解决办法，jdbc与sql服务器版本不同，需匹配一致，mysql是8.x的话，jdbc换成mysql-connector-java-8.x版本

并且驱动：Class.forName("com.mysql.jdbc.Driver");

改成：Class.forName("com.mysql.cj.jdbc.Driver");

最后还可能出现

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.

那么连接获取的url由：jdbc:mysql://localhost:3306/db1

改成：jdbc:mysql://localhost:3306/db1?serverTimezone=GMT%2B8

jdbc8百度网盘链接：链接：https://pan.baidu.com/s/1f1NTYGZ_hIQ8XU4f41gNpw
提取码：qw2s