Can't Connect to MySQL using ClearText Password

已完成

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

3

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

0

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

3
Avatar
Permanently deleted user

The workaround didn't work for me. 

0

Thank you Rafael, it worked for me (even after 3 years)

1

Thank you Rafael - worked for me like a charm! 

0

请先登录再写评论。