springboot配置mysql数据库spring.datasource.url报错处理

最新推荐文章于 2025-06-24 21:05:58 发布

wandrong

最新推荐文章于 2025-06-24 21:05:58 发布

阅读量2.5w

点赞数

CC 4.0 BY-SA版权

分类专栏： mysql springboot 文章标签： mysql datasource useSSL

本文链接：https://blog.youkuaiyun.com/wandrong/article/details/83347267

mysql 同时被 2 个专栏收录

1 篇文章

订阅专栏

springboot

1 篇文章

订阅专栏

配置SpringBoot连接MySQL时遇到SSL连接警告，尝试设置useSSL=true后出现证书验证错误。解决方法是将useSSL设置为false，避免SSL连接验证，最终配置为：spring.datasource.url=jdbc:mysql://abc:3306/abcd?useUnicode=true&characterEncoding=utf8&useSSL=false。

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

spring.datasource.url=jdbc:mysql://abc:3306/abcd?useUnicode=true&characterEncoding=utf8

很常规地配置了这个mysql的url后发现报错

Wed Oct 24 14:59:16 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 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那指定useSSL这个属性

然后试过useSSL=true

spring.datasource.url=jdbc:mysql://abc:3306/abcd?useUnicode=true&characterEncoding=utf8&useSSL=true
又报了一个错

Caused by: java.security.cert.CertificateException: java.security.cert.CertPathValidatorException: Path does not chain with any of the trust anchors
   at com.mysql.jdbc.ExportControlled$X509TrustManagerWrapper.checkServerTrusted(ExportControlled.java:302)
   at sun.security.ssl.AbstractTrustManagerWrapper.checkServerTrusted(SSLContextImpl.java:984)
   at sun.security.ssl.ClientHandshaker.serverCertificate(ClientHandshaker.java:1496)
   ... 31 common frames omitted
Caused by: java.security.cert.CertPathValidatorException: Path does not chain with any of the trust anchors
   at sun.security.provider.certpath.PKIXCertPathValidator.validate(PKIXCertPathValidator.java:153)
   at sun.security.provider.certpath.PKIXCertPathValidator.engineValidate(PKIXCertPathValidator.java:79)
   at java.security.cert.CertPathValidator.validate(CertPathValidator.java:292)
   at com.mysql.jdbc.ExportControlled$X509TrustManagerWrapper.checkServerTrusted(ExportControlled.java:295)
   ... 33 common frames omitted

没有证书设置的话这里只能useSSL=false

最终这样设置

spring.datasource.url=jdbc:mysql://abc:3306/abcd?useUnicode=true&characterEncoding=utf8&useSSL=false