Java連接Mysql數據庫的過程中出現了如下的警告信息:
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.
警告提示:不建議使用沒有帶服務器身份驗證的SSL連接
解決方案:
1.如果做的是單一測試:在數據庫連接的url中添加useSSL=false;
jdbc:mysql://localhost:3306/demo_stu?useSSL=false
2.url中添加useSSL=true,并且提供服務器的驗證證書。
Properties properties = new Properties();
properties.setProperty("user", "root");
properties.setProperty("password", "1234");
properties.setProperty("useSSL", "false");
properties.setProperty("autoReconnect", "true");
try (Connection conn = DriverManager.getConnection(connectionUrl, properties)) {...
} catch (SQLException e) {...
}