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

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

#mysql

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

报错提示：

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 5521
自从升级了数据库版本到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 736
控制台警告： 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 1197
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-03 2322
Springboot-Mybatis 连接数据库 好久没用Springboot，今儿个用了下，在搭建数据库的时候发现： log框中提示： Wed Jun 03 23:41:30 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 SS
警告解决：Establishing SSL connection without server‘s identity verification is not recommended. Accordin
热门推荐
邵奈一的博客
05-09 3万+
进行需要连接数据库的操作时，控制台会报下面这个警告，看着不舒服，所以可以解决一下，你可以直接看英文，也能够看得懂。 Sun May 09 21:49:05 GMT+08:00 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 conne
Establishing SSL connection without server's identity verification is not recommended.
毫无技术含量的博客
06-14 730
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 212
当链接Mysql数据库时提示：MYSQL:WARN: Establishing SSL connection without server’s identity verification is not recommended. 只需要 jdbc:mysql://localhost:3306/"+dataBaseName+"?useUnicode=true&characterEncoding...
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 775
今天在做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....
SpringBoot连接Mysql数据库警告：Establishing SSL connection without server's identity verification is not rec...
weixin_30387423的博客
05-05 214
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 236
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...
mysql Establishing SSL connection without server's identity verificatio
清风自来
07-25 2335
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 165
链接数据库时控制台打印警告！  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 355
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 377
①<c3p0-config>     <!-- 默认配置，如果没有指定则使用这个配置 -->     <default-config>         <!-- 基本配置 -->         <property name="driverClass">com.mysql.jdbc.Driver</property> /
MySQL Establishing SSL connection without server's identity verification warning
南巷清风
04-09 215
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 335
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...
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 third party. This can be done by verifying the server's SSL certificate. If the client does not verify the server's identity, it may be vulnerable to man-in-the-middle attacks. Therefore, it is strongly advised to always enable server identity verification when establishing an SSL connection.
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值