Establishing SSL connection without server's identity verification is not recommended. According to

最新推荐文章于 2020-09-28 11:47:01 发布
原创 最新推荐文章于 2020-09-28 11:47:01 发布 · 267 阅读 · 0 ·
CC 4.0 BY-SA版权
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
文章标签：

#mysql

本文介绍了如何解决在使用MySQL时出现的SSL连接错误。主要提供了两种解决方案：一是显式禁用SSL，二是设置SSL验证并提供信任存储以验证服务器证书。

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

报错提示：

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.

看最后一段的意思是说：需要设置useSSL=false

看了下自己的代码才发现 连接后面没加



正确的是：

url: jdbc:mysql://127.0.0.1:3306/dbdemo?useUnicode=true&characterEncoding=utf-8&useSSL=false



解决：Establishing SSL connection without server‘s identity verification is not recommended警告
albatrossi的博客
07-11 5351
自从升级了数据库版本到8.0后，经常会在数据库连接时报错，根据日志来看即 不建议在没有服务器身份验证的情况下建立 SSL 连接。根据MySQL 5.5.45 +，5.6.26 +和5.7.6 +要求，如果未设置显式选项，则必须默认建立SSL连接。为了符合不使用 SSL 的现有应用程序，verifyServerCertificate 属性设置为“false”。您需要通过设置 useSSL=false 来显式禁用 SSL，或者设置 useSSL=true 并提供用于服务器证书验证的信任库。我原本的url设置如下
WARN: Establishing SSL connection without server‘s identity verification is not recommended.
yi234567bo的博客
12-12 703
控制台警告： 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
二、使用mysql-jdbc连接MySQL出现如下警告：Establishing SSL connection without server's identityverification
panchang199266的博客
03-27 1188
1.Java使用mysql-jdbc连接MySQL出现如下警告： Establishing SSL connection without server’s identityverification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+requirements SSL connection must be...
Establishing SSL connection without server's identity verification is not recommended.
毫无技术含量的博客
06-14 703
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...
当链接Mysql数据库时提示：MYSQL:WARN: Establishing SSL connection without server's identity verification is not
qq_19609195的博客
12-30 197
当链接Mysql数据库时提示：MYSQL:WARN: Establishing SSL connection without server’s identity verification is not recommended. 只需要 jdbc:mysql://localhost:3306/"+dataBaseName+"?useUnicode=true&characterEncoding...
SpringBoot连接Mysql数据库警告：Establishing SSL connection without server's identity verification is not rec...
weixin_30387423的博客
05-05 199
Java使用mysql-jdbc连接MySQL出现如下警告： 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 connec...
【警告】WARN: Establishing SSL connection without server's identity verification is not recommended....
weixin_30410999的博客
04-02 224
1.Java访问Mysql时出现如下警告： 2019-04-02 10:30:50.545 INFO 1290 --- [nio-8080-exec-1] com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Starting... Tue Apr 02 10:30:50 CST 2019 WARN: Establishing...
Thu Jun 13 22:42:10 CST 2024 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL
06-14
The warning "Establishing SSL connection without server's identity verification is not recommended" indicates that the client is attempting to establish a secure connection but isn't verifying the ...
连接MySQL出现警告问题：Establishing SSL connection without server‘s identity verification is not recommended.
meijindeng的博客
09-28 743
今天在做Java连接MySQL（JDBC）的时候，八个基本步骤已经完成，对数据库的数据也可进行正常的增删查改，可是IDEA还是会出现警告⚠，如下图所示 具体内容： Mon Sep 28 11:16:19 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+ requ
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 establish
最新发布
03-28
'ssl_disabled': False, # Set this to True if you want to disable SSL explicitly. } cnx = mysql.connector.connect(**config) cursor = cnx.cursor() query = ("SELECT * FROM employees LIMIT 1;") cursor....
mysql Establishing SSL connection without server's identity verificatio
清风自来
07-25 2226
Wed Jul 25 20:57:47 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 connection mus...
MYSQL:WARN: Establishing SSL connection without server's identity verification is not recommended.
养只狗名叫猫
12-25 147
链接数据库时控制台打印警告！  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 establ...
WARN: Establishing SSL connection without server's identity verification is not recommended. Accordi
pizipapabang
12-28 314
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
Mysql 相关问题 如JDBC连接MySQL时发出的警告WARN: Establishing SSL connection without ser
wrwhahah的博客
10-30 325
①<c3p0-config>     <!-- 默认配置，如果没有指定则使用这个配置 -->     <default-config>         <!-- 基本配置 -->         <property name="driverClass">com.mysql.jdbc.Driver</property> /
MySQL Establishing SSL connection without server's identity verification warning
南巷清风
04-09 200
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 connectio...
解决mysql数据库问题:Establishing SSL connection without server's identity verification is not recommended.
haiyangzhou01的博客
04-08 321
Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is `com.mysql.cj.jdbc.Driver'. The driver is automatically registered via the SPI and manual loading of the driver class...
Mon Oct 08 00:34:46 CST 2018 WARN: Establishing SSL connection without server's identity verificatio
zrcshendustudy的博客
10-08 778
情境再现： Mon Oct 08 00:34:46 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 connect...
WARN: Establishing SSL connection without server's identity verification is not recommended. Accordi...
weixin_34392906的博客
10-09 174
使用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....
Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+
03-30
documentation, when establishing an SSL connection between a client and a server, it is recommended to verify the server's identity to ensure the connection is secure and not being intercepted by a ...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值