启动日志MySQL SSL连接WARN日志解决方法在连接地址加上参数useSSL=false

最新推荐文章于 2025-05-11 22:49:23 发布
最新推荐文章于 2025-05-11 22:49:23 发布
阅读量1.2k 收藏
点赞数
CC 4.0 BY-SA版权
分类专栏： mysql 文章标签： mysql
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.youkuaiyun.com/lc8023xq/article/details/109334571
本文针对MySQL连接时出现的WARN级别日志警告，提供了详细的解释及解决方案。建议在URL中加入useSSL=false参数来禁用SSL连接，以避免因未验证服务器身份而导致的安全风险。

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

控制台WARN日志：

Wed Oct 28 15:50:40 CST 2020 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.

解决方法：

在url地址加上参数：
localhost:3306/demo?useSSL=false

解决JDBC连接MySQL时发出的警告WARN: Establishing SSL connection without server's identity verification ...
huang_xin2016的博客
03-30 9万+
对于稍微有点强迫症的我来说，每次正常加载MySQL驱动后，eclipse的控制台总是出现一行红色警告；Fri Mar 30 14:55:35 CST 2018 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+,...
MySQL入门教程：连接池的使用
zqy_zq_zxl的博客
10-07 3459
数据库连接池入门&log日志框架了解
WARN: Establishing SSL connection without server‘s identity verificatio
qq_42730111的博客
07-24 670
问题出处：使用数据源连接数据的时候 问题原因：警告：不建议在没有服务器身份验证的情况下建立SSL连接。根据MySQL 5.5.45+、5.6.26+和5.7.6+的要求，如果没有设置explicit选项，默认情况下必须建立SSL连接。为了符合不使用SSL的现有应用程序，verifyServerCertificate属性设置为“false”。您需要通过设置useSSL=false显式禁用SSL，或者设置useSSL=true并为服务器证书验证提供信任库。 解决方法：跳过SSL校验 解决一： "jdbc:mys
服务器mysql连接我碰到的错误
liu174的博客
05-11 526
可以访问这个地址。由于应用程序容器和MySQL容器位于不同的Docker网络中，应用程序容器可能无法直接访问宿主机的。2.我尝试使用我的服务器IP地址进行连接，心想反正映射了吧，我本地使用datagrip可以连上。我在服务器上使用docker部署了java项目与mysql，但mysql连接一直出现问题。1.首先，我使用的是localhost连接，心想反正都在服务器上吧。指的是当前计算机，服务是用一个个的docker部署的，，也需要确保运行应用程序的Docker容器（搞了2个下午，总算成功了。
解决：WARN: Establishing SSL connection without server‘s identity verification报错（一篇文章彻底解决！）
air_729的博客
06-14 1627
SpringBoot可以正常启动浏览器发送请求500idea检查控制台发现如下错误：查看翻译显示是数据库连接出的问题更改前：更改后：网上查找方法说更改一下就不会出错了，可是我的又出现了新的错误：HikariPool是springboot 2.x版本后的默认数据库连接池，所以，该问题还是出在数据库设置上。
警告:Establishing SSL connection without server's identity verification is not recommended
weixin_33737134的博客
06-04 253
SpringBoot启东时红色警告： Mon Jun 04 00:53:48 CST 2018 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ a...
mysql服务器证书验证提供信任库_MYSQL:WARN: Establishing SSL connection without server's identity verification is ...
weixin_42620202的博客
02-05 430
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 i...
Sat Jul 19 11:52:42 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. Sat Jul 19 11:52:42 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. Sat Jul 19 11:52:42 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. Sat Jul 19 11:52:42 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. Sat Jul 19 11:52:42 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. Sat Jul 19 11:52:42 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. Sat Jul 19 11:52:42 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. Sat Jul 19 11:52:42 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. Sat Jul 19 11:52:42 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.
最新发布
07-20
如果您不需要SSL加密（例如在本地开发或内部网络中），可以直接在MySQL连接URL中添加`useSSL=false`参数。这会跳过SSL连接，避免警告。 1. **修改连接字符串**： - 在您的应用程序配置文件中，找到MySQL连接URL...
Log4j配置案例：使用DBCP连接池集成MySQL存储日志
为了将log4j日志信息存储在MySQL数据库中，我们需要配置log4j连接数据库连接池。本文将详细解释如何使用dbcp数据库连接池作为例子来实现这一过程。 ### log4j配置基础 log4j是一个流行的日志记录库，它允许开发者...
MySQL Establishing SSL connection without server's identity verification warning
纱厨藤簟，玉人罗扇轻缣。
03-29 2万+
Spring boot试用MySQL数据库，应用启动时报如下警告：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...
MySql：Establishing SSL connection without server's identity verification is not recommended
韩超的博客 (hanchao5272)
01-10 6525
1.全部警告信息 Wed Jan 10 21:13:40 CST 2018 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 conn
MYSQL:WARN: Establishing SSL connection without server‘s identity verification is not recommended.
热门推荐
蚁人的博客
08-31 13万+
在JDBC连接Mysql数据库的过程中出现了如下的警告信息: 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...
解决:WARN: Establishing SSL connection without server‘s identity verification is not recommended
husky_bit的博客
09-28 2万+
根据MySQL 5.5.45+， 5.6.26+和5.7.6+的要求，如果没有设置显式选项，则必须默认建立SSL连接。您需要通过设置useSSL=false显式禁用SSL，或者设置useSSL=true并为服务器证书验证提供信任存储。原因是在MySQL 5.5.45+、5.6.26+和5.7.6+等版本中，不建议在没有服务器身份验证的情况下建立SSL连接。当然这只是不建议,如果我们非要这么做，也可以无视该警告信息，这只是一个警告信息，不会影响数据库的连接和使用。
解决：WARN: Establishing SSL connection without server‘s identity verification is not recommended.
君子不器的博客
05-22 6715
WARN: Establishing SSL connection without server's identity verification is not recommended.
连接mysql数据库警告： Establishing SSL connection without server‘s identity verification is not recommended.
hahaha_1112的博客
02-18 4424
连接mysql数据库警告： Establishing SSL connection without server's identity verification is not recommended.
MYSQL:WARN:Establishing SSL connection without server's identity verification is not recommended.
程序员的时光
06-23 1873
在JDBC连接数据库时出现了以下的警告： 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 e...
WARN: Establishing SSL connection without server's identity verific...
测试0901-1
10-09 367
使用idea编写程序连接数据库时出现以下问题 使用MySQL数据库时出现如下错误： WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5....
（解决）WARN: Establishing SSL connection without server‘s identity verification
qq_40662239的博客
03-08 6万+
Mon Mar 08 15:03:09 CST 2021 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
关于WARN: Establishing SSL connection without server‘s identity的解决方案
君子慎独，不欺暗室；卑以自牧，不欺于心
07-12 1万+
当你运行程序出来这个警告时： Sun Jul 12 12:06:56 CST 2020 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 o
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值