javaJDBC链接警告Establishing SSL connection without server's identity verification is not recommended.

最新推荐文章于 2024-06-17 21:12:22 发布

OnlyloveCuracao

最新推荐文章于 2024-06-17 21:12:22 发布

阅读量370

点赞数

CC 4.0 BY-SA版权

分类专栏： java JDBC

本文链接：https://blog.youkuaiyun.com/OnlyloveCuracao/article/details/83153528

java 同时被 2 个专栏收录

9 篇文章

订阅专栏

JDBC

3 篇文章

订阅专栏

本文详细解释了如何解决MySQL在建立SSL连接时未进行服务器身份验证的问题，通过修改getConnection的URL参数来避免警告，确保应用程序的正常运行。

错误提示：

Thu Oct 18 21:31:24 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.

当出现这种错误的时候说明MySQL是安装成功的，但是服务器没有身份认证，需要建SSL连接

只需要在getConnection的url参数后面加：?useUnicode=true&characterEncoding=utf-8&useSSL=false

即：

解决前：

con = DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/1","root","123456");

解决后：

con = DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/1?useUnicode=true&characterEncoding=utf-8&useSSL=false","root","123456");