JDBC警告Establishing SSL connection without server‘s identity verification is not recommended.

最新推荐文章于 2023-07-02 18:08:15 发布

原创最新推荐文章于 2023-07-02 18:08:15 发布 · 316 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#数据库 #database

本文介绍了解决初学者使用JDBC连接MySQL时遇到的SSLException错误的方法。通过在连接URL中明确设置useSSL参数为false来禁用SSL，以此提高传输效率。

初学者使用JDBC连接数据库的时候可能会出现下面的问题：

报错是SSLException，并且警告中说的是高版本的MySQL中需要指定是否使用ssl安全协定，所以我们需要在url里指明ssl协议的使用情况，因为使用ssl协议会降低传输效率，所以一般在自己写程序的时候可以不使用该协议，所以url应该写成如下形式：

jdbc:mysql://127.0.0.1:3306/db1?useSSL=false

注意这里的等号两边不要有空格，否则还是会报错

确定要放弃本次机会？

福利倒计时

: :

立减 ¥

普通VIP年卡可用

立即使用

Will_Che

关注关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
分享

复制链接

分享到 QQ

分享到新浪微博

扫一扫
举报

举报

使用eclipse连接mysql报错WARN: Establishing SSL connection without server's identity verification is not re

weixin_43968936的博客

10-30

1万+

错误信息如下：（一共两个错误，此贴只能解决第一个错误，访问被拒绝没有解决） 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...

解决：Establishing SSL connection without server‘s identity verification is not recommended警告

albatrossi的博客

07-11

5534

自从升级了数据库版本到8.0后，经常会在数据库连接时报错，根据日志来看即不建议在没有服务器身份验证的情况下建立 SSL 连接。根据MySQL 5.5.45 +，5.6.26 +和5.7.6 +要求，如果未设置显式选项，则必须默认建立SSL连接。为了符合不使用 SSL 的现有应用程序，verifyServerCertificate 属性设置为“false”。您需要通过设置 useSSL=false 来显式禁用 SSL，或者设置 useSSL=true 并提供用于服务器证书验证的信任库。我原本的url设置如下

参与评论您还未登录，请先登录后发表或查看评论

警告:Establishing SSL connection without server's identity verification is not recommended

weixin_33737134的博客

06-04

289

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...

Establishing SSL connection without server‘s identity verification is not re

一个天天与人打赌周更blog被迫极限一换一的程序员骚年

01-06

1580

在没有服务器身份验证的情况下建立SSL连接是无效的虽然只是个warn,不是error但是还是有点强迫症嘿。

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

HeatDeath的博客

10-26

717

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 ...

WARN: Establishing SSL connection without server‘s identity verification is not recommended.

yi234567bo的博客

12-12

738

控制台警告： 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出现警告问题：Establishing SSL connection without server‘s identity verification is not recommended.

meijindeng的博客

09-28

778

今天在做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

解决JDBC链接MySQL时发出的警告WARN:WARN: Establishing SSL connection without server‘s identity verification ...

要做大牛不要秃头的博客

01-06

8443

新手疑惑&强迫症福音!!! 作为一名大数据工作者 , 各类数据库是要经常用到的 , 有个小老弟问我为什么连接MySQL数据库时明明没有错误 , 控制台还是会一大片爆红 , 这是怎么肥四呢 ? Thu Jan 06 22:38:56 CST 2022 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.

WARN: Establishing SSL connection without server's identity verification is not recommended. Accordi

12-26

根据提供的引用内容，警告信息是关于在没有服务器身份验证的情况下建立SSL连接的。根据MySQL的要求，如果没有设置显式选项，默认必须建立SSL连接。为了符合不使用SSL的现有应用程序，可以通过设置useSSL=false来显式...

Establishing SSL connection without server‘s identity verification is not recommended.

夏末秋也凉的博客

07-02

325

在下图的目录层级中的url的末尾多加一个&useSSL=false即可。

2020-10-25

jingshuyunsi的博客

10-25

193

Sun Oct 25 11:31:28 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

警告:Establishing SSL connection without server’s identity verification is not recommended

qq_42723873的博客

08-31

266

翻译：请注意:不建议在没有服务器身份验证的情况下建立SSL连接。根据MySQL 5.5.45+、5.6.26+和5.7.6+的要求，如果不设置显式选项，则必须建立默认的SSL连接。您需要通过设置useSSL=false显式地禁用SSL，或者设置useSSL=true并为服务器证书验证提供信任存储解决：在jdbcUrl后面加上?useSSL=false ...

JDBC连接数据库时警告:Establishing SSL connection without server's identity verification is not recommended.

枫林晚的博客

08-31

627

警告信息为: Sat Aug 31 12:13:53 CST 2019 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...

Establishing SSL connection without server's identity verification is not recom

小么飞刀的博客

02-11

812

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...

Establishing SSL connection without server's identity verification is not recommended的简单解决方案

大鱼的博客

09-26

740

运行mybatis是出现警告： Wed Sep 26 20:25: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...

springboot连接Mysql时警告：Establishing SSL connection without server‘s identity verification is not re...

代码从一开始的博客

08-12

8619

1.完整错误： 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 exist

SpringBoot连接Mysql数据库警告：Establishing SSL connection without server's identity verification is not rec...

weixin_30387423的博客

05-05

216

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...