Establishing SSL connection without server's identity verification is not recommended. According to

最新推荐文章于 2024-05-22 15:26:44 发布

原创最新推荐文章于 2024-05-22 15:26:44 发布 · 672 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#Establishing SSL connection #requirements SSL connection mu

mysql 专栏收录该内容

10 篇文章

订阅专栏

本文解决了一个常见的问题：当使用Java通过mysql-jdbc连接MySQL时出现的SSL连接警告。提供了两种解决方案：一是设置useSSL为true并提供信任存储进行服务器证书验证；二是明确禁用SSL，即将useSSL设置为false。

问题：Java使用mysql-jdbc连接MySQL出现如下警告
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连接字符串url中加入ssl=true或者false即可，如下所示。
url=jdbc:mysql://127.0.0.1:3306/framework?characterEncoding=utf8&useSSL=true