Can't Connect to MySQL using ClearText Password

Completed

I'm trying to connect to an Amazon RDS MySQL instance.

We use generated passwords that expire daily and we have to connect sending this password as Clear Text

I've updated the following properties to try and make it work

authenticationPlugins -  com.mysql.jdbc.authentication.MysqlClearPasswordPlugin

 

defaultAuthenticationPlugin - com.mysql.jdbc.authentication.MysqlClearPasswordPlugin

 

The generated password works on other IDEs such as SequelPro

2 comments
Comment actions Permalink

I managed to solve the issue.

 

I've followed the instuctions found online. still got the error and went to investigate. finally i found out it was because IntelliJ wasn't able to find the Plugin Class.

So I went after it and discovered that the package had changed.

I believe it is because we're using a newer version of the connector.

 

  • set ptoperty authenticationPlugin = com.mysql.cj.protocol.a.authentication.MysqlClearPasswordPlugin
  • add env variable: LIBMYSQL_ENABLE_CLEARTEXT_PLUGIN=1

1
Comment actions Permalink

@Ametersky
Could you try a workaround mentioned in https://youtrack.jetbrains.com/issue/DBE-6039 ?

0

Please sign in to leave a comment.