为了账号安全,请及时绑定邮箱和手机立即绑定

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

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

慕仰1489937 2017-02-13 12:57:38
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 回答

?
习惯受伤

TA贡献885条经验 获得超1144个赞

第一点,你的driverclass怎么是:

Class.forName("com.mysql.cj.jdbc.Driver");

而不是:

Class.forName("com.mysql.jdbc.Driver");

第二:如果你已经加了useSSL=false 你换一个其他版本,如:5.1.35 试试。

查看完整回答
2 反对 回复 2017-02-13
  • 12344554
    12344554
    spring.datasource.url=jdbc:mysql://localhost:3306/bonc?useUnicode=true&characterEncoding=utf-8&useSSL=false 加上useSSL=false即可
  • 慕侠1054529
    慕侠1054529
    mysql8 需要修改驱动为Class.forName("com.mysql.cj.jdbc.Driver");
  • 1 回答
  • 0 关注
  • 13220 浏览
慕课专栏
更多

添加回答

举报

0/150
提交
取消
意见反馈 帮助中心 APP下载
官方微信