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+ requiremen

使用idea編寫程式連接配接資料庫時出現以下問題

使用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.

網上查了查，是目前版本的MySQL要求使用SSL，做出如下修改即可：

将

connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/jsp_db","root","123456");

改成

connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/jsp_db?useSSL=false","root","123456");

問題解決。

作者：南大

連結：http://www.jianshu.com/p/a813450f5341

來源：簡書

著作權歸作者所有。商業轉載請聯系作者獲得授權，非商業轉載請注明出處。