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

最新推荐文章于 2024-06-14 17:08:24 发布
原创 最新推荐文章于 2024-06-14 17:08:24 发布 · 1.2k 阅读 · 0 ·
CC 4.0 BY-SA版权
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
文章标签：

#mysql

本文针对MySQL连接时出现的WARN级别日志警告，提供了详细的解释及解决方案。建议在URL中加入useSSL=false参数来禁用SSL连接，以避免因未验证服务器身份而导致的安全风险。

控制台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出现警告问题：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警告
albatrossi的博客
07-11 5504
自从升级了数据库版本到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 verificatio
qq_42730111的博客
07-24 690
问题出处：使用数据源连接数据的时候 问题原因：警告：不建议在没有服务器身份验证的情况下建立SSL连接。根据MySQL 5.5.45+、5.6.26+和5.7.6+的要求，如果没有设置explicit选项，默认情况下必须建立SSL连接。为了符合不使用SSL的现有应用程序，verifyServerCertificate属性设置为“false”。您需要通过设置useSSL=false显式禁用SSL，或者设置useSSL=true并为服务器证书验证提供信任库。 解决方法：跳过SSL校验 解决一： "jdbc:mys
解决：WARN: Establishing SSL connection without server‘s identity verification报错（一篇文章彻底解决！）
air_729的博客
06-14 1876
SpringBoot可以正常启动浏览器发送请求500idea检查控制台发现如下错误：查看翻译显示是数据库连接出的问题更改前：更改后：网上查找方法说更改一下就不会出错了，可是我的又出现了新的错误：HikariPool是springboot 2.x版本后的默认数据库连接池，所以，该问题还是出在数据库设置上。
tomcat日志警告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.
最新发布
11-27
当Tomcat日志中出现“Establishing SSL connection without server's identity verification is not recommended...”警告，这是因为在建立MySQL连接时没有进行服务器身份验证，以下是几种解决方法： ### 方法一：...
明确配置useSSL=false，还是会报错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.
05-07
好的，我现在需要帮助用户解决在已经明确配置了useSSL=false后仍然出现MySQL SSL连接警告的问题。用户提到他们使用的是MySQL 5.5.45+、5.6.26+和5.7.6+版本，所以必须考虑到这些版本的特殊要求。 首先，我要回顾...
# ======================================================== # 公共配置：激活开发环境 # ======================================================== spring: profiles: active: dev # ======================================================== # 项目自定义配置 # ======================================================== ruoyi: name: RuoYi version: 4.8.1 copyrightYear: 2025 demoEnabled: true profile: D:/ruoyi/uploadPath/ # 文件上传根路径 addressEnabled: false # ======================================================== # 用户登录与密码策略配置（关键！修复 Bean 注入失败） # ======================================================== user: password: maxRetryCount: 5 # 密码错误最大重试次数 lockTime: 30 # 账号锁定时间（分钟） maxOnlineUsers: 20 # 最大在线用户数（用于踢出策略） # ======================================================== # 开发环境配置 (profile: dev) # ======================================================== --- spring: profiles: dev # ------------------------ # 数据源配置（Druid） # ------------------------ datasource: url: jdbc:mysql://localhost:3306/ry?useSSL=false&serverTimezone=Asia/Shanghai&characterEncoding=utf8 username: root password: ${MYSQL_PASSWORD:123456} driver-class-name: com.mysql.cj.jdbc.Driver # 显式声明驱动类更安全 druid: # --- 连接池参数 --- initialSize: 5 minIdle: 5 maxActive: 20 maxWait: 60000 validationQuery: SELECT 1 testWhileIdle: true testOnBorrow: false testOnReturn: false timeBetweenEvictionRunsMillis: 60000 minEvictableIdleTimeMillis: 300000 poolPreparedStatements: true maxPoolPreparedStatementPerConnectionSize: 20 # ============================= # 【✅ 关键修复】必须显式指定数据库类型 # ============================= db-type: mysql # 👈 Druid 不会自动推断此值，必须手动设置！ # --- 监控页面 --- statViewServlet: enabled: true urlPattern: /druid/* loginUsername: admin loginPassword: ${DRUID_PASSWORD:admin123} allow: 127.0.0.1,192.168.1.100 deny: resetEnable: false # --- Web 统计过滤器 --- webStatFilter: enabled: true urlPattern: /* exclusions: "*.js,*.gif,*.jpg,*.png,*.css,*.ico,/druid/*" # --- SQL 监控与防火墙 --- filter: stat: enabled: true logSlowSql: true slowSqlMillis: 1000 mergeSql: true wall: enabled: true # ============================= # 【✅ 再次强调】wall 模块也需要 db-type # ============================= db-type: mysql # 👈 防止 WallFilter 初始化时报 NPE config: dropTableAllow: false # 禁止执行 DROP TABLE # ------------------------ # Thymeleaf 模板引擎 # ------------------------ thymeleaf: mode: HTML encoding: utf-8 cache: false enabled: true suffix: .html prefix: classpath:/templates/ # ------------------------ # 国际化消息 # ------------------------ messages: basename: static/i18n/messages encoding: UTF-8 # ------------------------ # Jackson JSON 处理 # ------------------------ jackson: timeZone: GMT+8 dateFormat: yyyy-MM-dd HH:mm:ss defaultPropertyInclusion: NON_NULL # ------------------------ # 文件上传 # ------------------------ servlet: multipart: maxFileSize: 10MB maxRequestSize: 20MB # ------------------------ # DevTools # ------------------------ devtools: restart: enabled: true livereload: enabled: true # ------------------------ # 应用名称 # ------------------------ application: name: ruoyi-admin # ======================================================== # Server 配置 # ======================================================== server: port: 80 servlet: context-path: / tomcat: uri-encoding: UTF-8 accept-count: 1000 threads: max: 800 min-spare: 100 # ======================================================== # 日志配置（必须确保 logback-spring.xml 存在） # ======================================================== logging: level: com.ruoyi: info com.ruoyi.mapper: debug org.springframework: warn org.apache.ibatis: debug config: classpath:logback-spring.xml # ======================================================== # MyBatis 配置 # ======================================================== mybatis: typeAliasesPackage: com.ruoyi.**.domain mapperLocations: classpath*:mapper/**/*Mapper.xml configLocation: classpath:mybatis/mybatis-config.xml # ======================================================== # PageHelper 分页插件 # ======================================================== pagehelper: helperDialect: mysql supportMethodsArguments: true params: count=countSql # ======================================================== # Shiro 安全框架 # ======================================================== shiro: user: loginUrl: /login unauthorizedUrl: /unauth indexUrl: /index captchaEnabled: true captchaType: math cookie: domain: path: / httpOnly: true maxAge: 30 cipherKey: session: expireTime: 30 dbSyncPeriod: 1 validationInterval: 10 maxSession: -1 kickoutAfter: false rememberMe: enabled: true # ======================================================== # XSS 防护 # ======================================================== xss: enabled: true excludes: /system/notice/* urlPatterns: /system/*,/monitor/*,/tool/* # ======================================================== # CSRF 防护 # ======================================================== csrf: enabled: false whites: /druid # ======================================================== # Swagger API 文档 # ======================================================== swagger: enabled: true 删掉那部分，完整展示修改后的代码
11-22
useSSL=false&serverTimezone=Asia/Shanghai&characterEncoding=utf8 username: root password: ${MYSQL_PASSWORD:123456} driver-class-name: com.mysql.cj.jdbc.Driver # 显式声明驱动类更安全 # ❌ 删除...
警告:Establishing SSL connection without server's identity verification is not recommended
weixin_33737134的博客
06-04 282
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 445
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 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 6619
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 6844
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 4469
连接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 1897
在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 387
使用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
评论
成就一亿技术人!
拼手气红包6.0元
还能输入1000个字符
 
红包 添加红包
表情包 插入表情
表情包 代码片
 条评论被折叠 查看
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值