这是为什么？WARN: Establishing SSL connection without server's identity verification is not recommen

Question

Mon Feb 13 11:50:47 CST 2017 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.

package my_test;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.Statement;

import org.junit.Test;

public class Test_1 {

@Test
public void test_1() throws Exception {
 Class.forName("com.mysql.cj.jdbc.Driver");

 Connection connection = DriverManager.getConnection(
   "jdbc:mysql://localhost:3306/school?"
   + "useUnicode=true&characterEncoding=utf-8&useSSL=false", "root",
   "3579waai,,,");
 System.out.println(connection);

 Statement state = connection.createStatement();
 String sql = "CREATE TABLE s_class (id int(10),name char(10));";
 state.execute(sql);
 
 connection.close();
 state.close();

}
}

• 补充：mysql-connector-java-5.1.40 jdk是1.8 MySQL是5.7 这是为什么？

Answer 1

第一点，你的driverclass怎么是：Class.forName("com.mysql.cj.jdbc.Driver");而不是：Class.forName("com.mysql.jdbc.Driver");第二：如果你已经加了useSSL=false 你换一个其他版本，如：5.1.35 试试。