Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Warning: Establishing SSL connection without server's identity verification is not recommended [duplicate]

Tags:

When connecting a MySQL database I get the warning below:

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.

please help me out from this problem

import java.sql.*;
public class JdbcCreateTable {
public static void main(String args[])
{
    try
    {
        Class.forName("com.mysql.jdbc.Driver");
    }
    catch(ClassNotFoundException e)
    {
        e.printStackTrace();
    }
    try{
        Connection con=DriverManager.getConnection("jdbc:mysql://localhost:3306/INTtech","root","root");
        Statement st=con.createStatement();
        int i=st.executeUpdate("create table Author(AID int primary key,Aname varchar(20),AContact no int,ACountry string)");
        System.out.println("Table is created"+i);
        con.close();
    }
    catch(SQLException e)
    {
        e.printStackTrace();
    }
}
}
like image 328
relangi rajeshwari Avatar asked Dec 11 '15 13:12

relangi rajeshwari


People also ask

How do I fix establishing SSL connection without server's identity verification is not recommended?

You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.

What is the use of useSSL?

5 and earlier, in which case the client must set the connection property useSSL=true in order to use encrypted connections). The client can demand SSL to be used by setting the connection property requireSSL=true ; the connection then fails if the server is not configured to use SSL.

How do I disable SSL in SQL Workbench?

mysql/workbench/connections. xml , look for the connection that you want to disable ssl, and find <value type="int" key="useSSL">2</value> set it to 0, that will disable ssl for that connection.

How disable SSL in MySQL?

Disabling SSL in MySQL If your requirement is to completely turn off SSL on MySQL server instead of the default option of 'enabled, but optional mode', we can do the following: Delete the *. pem certificate and key files in the MySQL data directory. Start MySQL with SSL option turned off.


1 Answers

Put the useSSL=false at the end of the name database:

Connection con=DriverManager.getConnection("jdbc:mysql://localhost:3306/INTtech?useSSL=false","root","root");
like image 159
Edvan Souza Avatar answered Sep 23 '22 12:09

Edvan Souza