New MySQL driver causes java.sql.SQLNonTransientConnectionException: CLIENT_PLUGIN_AUTH is required

Question

When I am changing MySQL JDBC driver from 5.1.38 to 6.0.2 I am getting the following exception

java.sql.SQLNonTransientConnectionException: CLIENT_PLUGIN_AUTH is required

This exception happened in normal JDBC initialization.

Probably, this can be related to SSL, since I am getting the following messages also 

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.

which was absent in the previous version.

Answer 1

The newer versions of the MySQL connector (from 6 on) are not compatible with the old version of the DBMS MySQL(below 5.6). So to solve the problem, if you make an update of MySQL connector, try to do the same with the DBMS. Actually, I too had the same issue with the MySQL connector 8.0.13 and the DBMS MySQL 5.1. I solved it by updating the DBMS to 5.6.17

Interested in SQL ? Check out this SQL Certification by Intellipaat.

For more information visit :