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
这是为什么?
1 回答
![?](http://img1.sycdn.imooc.com/583d2ab20001050406400640-100-100.jpg)
习惯受伤
TA贡献885条经验 获得超1144个赞
第一点,你的driverclass怎么是:
Class.forName("com.mysql.cj.jdbc.Driver");
而不是:
Class.forName("com.mysql.jdbc.Driver");
第二:如果你已经加了useSSL=false 你换一个其他版本,如:5.1.35 试试。
添加回答
举报
0/150
提交
取消