关于WARN: Establishing SSL connection without server‘s identity的解决方案，idea导入项目后无法连接数据库

最新推荐文章于 2023-07-11 08:41:02 发布

only-qi

最新推荐文章于 2023-07-11 08:41:02 发布

阅读量714

点赞数

分类专栏：开发遇到的bug 文章标签： mysql 数据库

本文链接：https://blog.csdn.net/guoqi_666/article/details/107535737

版权

开发遇到的bug 专栏收录该内容

20 篇文章 0 订阅

订阅专栏

当你运行程序出来这个警告时：

Sun Jul 12 12:06:56 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改成这样

url: jdbc:mysql://localhost:3306/test1?useUnicode=true&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&serverTimezone=UTC&useSSL=false

注解：test1为数据库名字