MySQL warning warn:establishing SSL connection without server ' s identity verification is not recommended. workaround

Fri June 13:46:54 CST 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 is established by default if explicit Opti On isn ' t set. For compliance with existing applications not using SSL, the Verifyservercertificate property was set to ' false '. You need either to explicitly disable SSL by setting Usessl=false, or set usessl=true and provide truststore for server CE Rtificate verification.

First of all, when this occurs, the MySQL instructions have been installed successfully, this is a warning is not an error, later use is not affected. This means that an SSL connection is established, but the server does not have authentication, which is not recommended.

Workaround:

The original connection url:connection connect = drivermanager.getconnection ("Jdbc:mysql://localhost:3306/test", "root", "letmein");

Connect now Url:connection connect = drivermanager.getconnection ("Jdbc:mysql://localhost:3306/test? useunicode=true &characterencoding=utf-8&usessl=false"," root "," letmein ");
The connection URL is the jdbc:mysql//server address/database name, and the following 2 parameters are login username and password, respectively

MySQL warning warn:establishing SSL connection without server ' s identity verification is not recommended. workaround