MySQL Bugs: #79393: SSL connection required for plugin 'mysql_clear

Bug #79393	SSL connection required for plugin 'mysql_clear_password'. Check if "useSSL" is
Submitted:	24 Nov 2015 7:38	Modified:	1 Dec 2015 12:52
Reporter:	KIRAN KUMAR REDDY MACHA	Email Updates:
Status:	Not a Bug	Impact on me:	None
Category:	Connector / J	Severity:	S3 (Non-critical)
Version:	5.1.137	OS:	CentOS
Assigned to:	Alexander Soklakov	CPU Architecture:	Any

Description:
When I try to connect to a Database through JDBC, I was been getting the following exception

java.sql.SQLException: SSL connection required for plugin 'mysql_clear_password'. Check if "useSSL" is set to "true".
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:925)
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:922)
	at com.mysql.jdbc.MysqlIO.checkConfidentiality(MysqlIO.java:1636)
	at com.mysql.jdbc.MysqlIO.proceedHandshakeWithPluggableAuthentication(MysqlIO.java:1773)
	at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1288)
	at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2506)
	at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2539)
	at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2321)
	at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:832)
	at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:46)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
	at java.lang.reflect.Constructor.newInstance(Constructor.java:525)
	at com.mysql.jdbc.Util.handleNewInstance(Util.java:409)
	at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:417)
	at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:344)
	at java.sql.DriverManager.getConnection(DriverManager.java:579)
	at java.sql.DriverManager.getConnection(DriverManager.java:243)

I have been using SQLyog to connect the DB server, where there is checkbox with Enable Cleartext Plugin which works when it is checked and the same error comes when it is unchecked

How to repeat:
Try to connect to a DB which has to be connected through SSL using connector/J and it is not allowing to connect 

Authentication Plugin 'mysql_clear_password' cannot be loaded, plugin not enabled.

Hi Kiran,

Most likely, if server isn't configured to use 'mysql_clear_password' as a default, the user you're trying to connect with is created using IDENTIFIED WITH mysql_clear_password clause. Please check and alter user using appropriate plugin, see http://dev.mysql.com/doc/refman/5.7/en/alter-user.html

I'm closing this report as not a bug, because there is nothing to do in c/J re this failure.

Thanks,
Alex