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

接口报错

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

解决方案

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

上一篇:es6总结


下一篇:70:内网安全-域横向内网漫游Socks代理隧道技术