JDBC连接Mysql Log提示 According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be

本文介绍如何通过配置JDBC连接参数useSSL=false来消除Mysql5.6及以上版本中频繁出现的关于SSL连接未验证服务器身份的警告信息。

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

用JDBC连接Mysql 5.6的时候,log里面一直有如下的warning, 虽然并不是error,但是log里面在每次连接数据库的时候会一直打印这个warning.

WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.


可以在JDBC的配置里面添加useSSL=false配置使用非SSL连接即可:

jdbc.url=jdbc:mysql://localhost:3306/jeecmsv8?useUnicode=true&characterEncoding=UTF-8&useSSL=false


24-Jun-2025 07:49:42.304 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log Server.服务器版本: Apache Tomcat/9.0.106 24-Jun-2025 07:49:42.308 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log 服务器构建: Jun 5 2025 19:02:30 UTC 24-Jun-2025 07:49:42.309 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log 服务器版本号: 9.0.106.0 24-Jun-2025 07:49:42.309 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log 操作系统名称: Windows 10 24-Jun-2025 07:49:42.309 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log OS.版本: 10.0 24-Jun-2025 07:49:42.309 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log 架构: amd64 24-Jun-2025 07:49:42.309 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log Java 环境变量: C:\jdk-11.0.7 24-Jun-2025 07:49:42.309 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log Java虚拟机版本: 11.0.7+8-LTS 24-Jun-2025 07:49:42.309 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log JVM.供应商: Oracle Corporation 24-Jun-2025 07:49:42.309 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log CATALINA_BASE: C:\Users\25230\AppData\Local\JetBrains\IntelliJIdea2023.2\tomcat\1e0b5b64-db26-45a1-a2b7-4d9004a7876d 24-Jun-2025 07:49:42.309 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log CATALINA_HOME: C:\develop\tomcat\apache-tomcat-9.0.106-windows-x64\apache-tomcat-9.0.106 24-Jun-2025 07:49:42.309 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log 命令行参数: --add-opens=java.base/java.lang=ALL-UNNAMED 24-Jun-2025 07:49:42.309 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log 命令行参数: --add-opens=java.base/java.lang.invoke=ALL-UNNAMED 24-Jun-2025 07:49:42.310 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log 命令行参数: --add-opens=java.base/java.lang.reflect=ALL-UNNAMED 24-Jun-2025 07:49:42.310 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log 命令行参数: --add-opens=java.base/java.io=ALL-UNNAMED 24-Jun-2025 07:49:42.310 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log 命令行参数: --add-opens=java.base/java.util=ALL-UNNAMED 24-Jun-2025 07:49:42.310 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log 命令行参数: --add-opens=java.base/java.util.concurrent=ALL-UNNAMED 24-Jun-2025 07:49:42.310 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log 命令行参数: --add-opens=java.rmi/sun.rmi.transport=ALL-UNNAMED 24-Jun-2025 07:49:42.310 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log 命令行参数: -Djava.util.logging.config.file=C:\Users\25230\AppData\Local\JetBrains\IntelliJIdea2023.2\tomcat\1e0b5b64-db26-45a1-a2b7-4d9004a7876d\conf\logging.properties 24-Jun-2025 07:49:42.310 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log 命令行参数: -Djava.util.logging.manager=org.apache.juli.ClassLoaderLogManager 24-Jun-2025 07:49:42.310 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log 命令行参数: -Dcom.sun.management.jmxremote= 24-Jun-2025 07:49:42.310 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log 命令行参数: -Dcom.sun.management.jmxremote.port=1099 24-Jun-2025 07:49:42.311 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log 命令行参数: -Dcom.sun.management.jmxremote.ssl=false 24-Jun-2025 07:49:42.311 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log 命令行参数: -Dcom.sun.management.jmxremote.password.file=C:\Users\25230\AppData\Local\JetBrains\IntelliJIdea2023.2\tomcat\1e0b5b64-db26-45a1-a2b7-4d9004a7876d\jmxremote.password 24-Jun-2025 07:49:42.311 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log 命令行参数: -Dcom.sun.management.jmxremote.access.file=C:\Users\25230\AppData\Local\JetBrains\IntelliJIdea2023.2\tomcat\1e0b5b64-db26-45a1-a2b7-4d9004a7876d\jmxremote.access 24-Jun-2025 07:49:42.311 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log 命令行参数: -Djava.rmi.server.hostname=127.0.0.1 24-Jun-2025 07:49:42.311 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log 命令行参数: -Djdk.tls.ephemeralDHKeySize=2048 24-Jun-2025 07:49:42.311 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log 命令行参数: -Djava.protocol.handler.pkgs=org.apache.catalina.webresources 24-Jun-2025 07:49:42.311 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log 命令行参数: -Dsun.io.useCanonCaches=false 24-Jun-2025 07:49:42.311 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log 命令行参数: -Dignore.endorsed.dirs= 24-Jun-2025 07:49:42.311 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log 命令行参数: -Dcatalina.base=C:\Users\25230\AppData\Local\JetBrains\IntelliJIdea2023.2\tomcat\1e0b5b64-db26-45a1-a2b7-4d9004a7876d 24-Jun-2025 07:49:42.311 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log 命令行参数: -Dcatalina.home=C:\develop\tomcat\apache-tomcat-9.0.106-windows-x64\apache-tomcat-9.0.106 24-Jun-2025 07:49:42.312 信息 [main] org.apache.catalina.startup.VersionLoggerListener.log 命令行参数: -Djava.io.tmpdir=C:\develop\tomcat\apache-tomcat-9.0.106-windows-x64\apache-tomcat-9.0.106\temp 24-Jun-2025 07:49:42.315 信息 [main] org.apache.catalina.core.AprLifecycleListener.lifecycleEvent 使用APR版本[1.7.4]加载了基于APR的Apache Tomcat本机库[1.3.1]。 24-Jun-2025 07:49:42.315 信息 [main] org.apache.catalina.core.AprLifecycleListener.lifecycleEvent APR功能:IPv6[true]、sendfile[true]、accept filters[false]、random[true]、UDS [true]。 24-Jun-2025 07:49:42.315 信息 [main] org.apache.catalina.core.AprLifecycleListener.lifecycleEvent APR/OpenSSL配置:useAprConnector[false],useOpenSSL[true] 24-Jun-2025 07:49:42.319 信息 [main] org.apache.catalina.core.AprLifecycleListener.initializeSSL OpenSSL成功初始化 [OpenSSL 3.0.14 4 Jun 2024] 24-Jun-2025 07:49:42.447 信息 [main] org.apache.coyote.AbstractProtocol.init 初始化协议处理器 ["http-nio-8080"] 24-Jun-2025 07:49:42.460 信息 [main] org.apache.catalina.startup.Catalina.load 服务器在[326]毫秒内初始化 24-Jun-2025 07:49:42.509 信息 [main] org.apache.catalina.core.StandardService.startInternal 正在启动服务[Catalina] 24-Jun-2025 07:49:42.509 信息 [main] org.apache.catalina.core.StandardEngine.startInternal 正在启动 Servlet 引擎:[Apache Tomcat/9.0.106] 24-Jun-2025 07:49:42.523 信息 [main] org.apache.coyote.AbstractProtocol.start 开始协议处理句柄["http-nio-8080"] 24-Jun-2025 07:49:42.538 信息 [main] org.apache.catalina.startup.Catalina.start [77]毫秒后服务器启动 已连接到服务器 [2025-06-24 07:49:42,553] 工件 ssmd539t:war: 正在部署工件,请稍候… 24-Jun-2025 07:49:49.697 信息 [RMI TCP Connection(2)-127.0.0.1] org.apache.jasper.servlet.TldScanner.scanJars 至少有一个JAR被扫描用于TLD但尚未包含TLD。 为此记录器启用调试日志记录,以获取已扫描但未在其中找到TLD的完整JAR列表。 在扫描期间跳过不需要的JAR可以缩短启动时间和JSP编译时间。 2025-06-24 07:49:49 -0 [RMI TCP Connection(2)-127.0.0.1] INFO - Root WebApplicationContext: initialization started 2025-06-24 07:49:50 -109 [RMI TCP Connection(2)-127.0.0.1] INFO - Refreshing Root WebApplicationContext: startup date [Tue Jun 24 07:49:50 CST 2025]; root of context hierarchy 2025-06-24 07:49:50 -186 [RMI TCP Connection(2)-127.0.0.1] INFO - Loading XML bean definitions from class path resource [spring/spring.xml] 2025-06-24 07:49:50 -466 [RMI TCP Connection(2)-127.0.0.1] INFO - Loading XML bean definitions from class path resource [spring/spring-mybatis.xml] 2025-06-24 07:49:51 -1415 [RMI TCP Connection(2)-127.0.0.1] ERROR - maxIdle is deprecated 2025-06-24 07:49:51 -1512 [RMI TCP Connection(2)-127.0.0.1] INFO - {dataSource-1} inited Tue Jun 24 07:49:52 CST 2025 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification. 2025-06-24 07:49:52 -2419 [Druid-ConnectionPool-Create-2093990188] ERROR - create connection error, url: jdbc:mysql://127.0.0.1:3306/ssmd539t?useUnicode=true&characterEncoding=UTF-8&tinyInt1isBit=false, errorCode 0, state 08001 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:404)
最新发布
06-25
评论 2
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

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

抵扣说明:

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

余额充值