Java教程

java springboot项目jdbc无法和mysql5.7建立SSL连接

本文主要是介绍java springboot项目jdbc无法和mysql5.7建立SSL连接,对大家解决编程问题具有一定的参考价值,需要的程序猿们随着小编来一起学习吧!

控制台报错


详细消息:
hu Feb 24 18:12:13 CST 2022 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.
2022-02-24 18:12:14.320 ERROR 3941 --- [nio-8089-exec-1] com.zaxxer.hikari.pool.HikariPool : HikariPool-1 - Exception during pool initialization.
com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

接口报错

解决方案

在jdbc配置里给datasource.url加上&useSSL=false
spring.datasource.url=jdbc:mysql://127.0.0.1:3306/mydb?useUnicode=true&characterEncoding=utf8&useSSL=false

这篇关于java springboot项目jdbc无法和mysql5.7建立SSL连接的文章就介绍到这儿,希望我们推荐的文章对大家有所帮助,也希望大家多多支持为之网!