Establishing SSL connection without server's identity verification is not recommended警告原因是mysql在高版本中

最新推荐文章于 2024-05-22 15:26:44 发布

原创最新推荐文章于 2024-05-22 15:26:44 发布 · 486 阅读

0 ·

CC 4.0 BY-SA版权

本文解决在Eclipse中部署Javaweb项目时遇到的数据库连接错误，特别是关于SSL连接的问题。提供了两种解决方案：一是修改mysql连接配置文件添加ssl参数；二是确保Tomcat和web项目下的MySql驱动版本一致。

在eclipse中部署Javaweb项目连接数据库报

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

错误时有两种可能：

1.原因是mysql在高版本中需要显式指定是否进行SSL连接。

在连接mysql配置文件中添加ssl=true即可

connectionURL="jdbc:mysql://localhost:3306/xxxxx?useSSL=true"

2.上述操作后仍报错，无法连接数据库服务则可能是在tomcat lib目录下的MySql驱动和web项目WEB-INF/lib 目录下的MySq驱动版本号不同

确定要放弃本次机会？

福利倒计时

: :

立减 ¥

普通VIP年卡可用

立即使用

FuNz_

关注关注

2
点赞
踩
0

收藏

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

复制链接

分享到 QQ

分享到新浪微博

扫一扫
举报

举报

Establishing SSL connection without server identity verification is not recommended

悟已往之不谏，知来者之可追

06-17

546

报错 SpringBoot启动时报错： Wed Jun 17 10:13:14 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 expli

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

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

Hive在使用MySQL5.7的数据库会提示：WARN: Establishing SSL connection without server's identity verification ...

muyingmiao的专栏

10-28

593

Hive在使用过程中，会提示 hive (default)> show databases; Mon Oct 28 19:26:54 CST 2019 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.4...

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

穹顶之下

01-04

1100

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 expli

解决：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设置如下

连接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

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

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

LFF1991的博客

08-18

852

Exception description(异常描述)：Fri Aug 18 09:00:08 CST 2017 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：Establishing SSL connection without server's identity verification is not recommended

又言又语

03-19

2242

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

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

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

Will_Che的博客

05-25

316

初学者使用JDBC连接数据库的时候可能会出现下面的问题：报错是SSLException，并且警告中说的是高版本的MySQL中需要指定是否使用ssl安全协定，所以我们需要在url里指明ssl协议的使用情况，因为使用ssl协议会降低传输效率，所以一般在自己写程序的时候可以不使用该协议，所以url应该写成如下形式： jdbc:mysql://127.0.0.1:3306/db1?useSSL=false 注意这里的等号两边不要有空格，否则还是会报错 ...

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

Ginny_2019的博客

04-03

449

问题描述注：请注意:不建议在没有服务器身份验证的情况下建立SSL连接。根据MySQL 5.5.45+、5.6.26+和5.7.6+的要求，如果不设置显式选项，则必须建立默认的SSL连接。您需要通过设置useSSL=false显式地禁用SSL，或者设置useSSL=true并为服务器证书验证提供信任存储解决方案 jdbc:mysql://127.0.0.1:3306/test?useU...

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

王洋的专栏

03-03

2656

Fri Mar 03 11:34:32 CST 2017 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

MySQL出现Establishing SSL connection without server's identity verification is not recommended

aa32360的博客

06-13

228

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

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