Unable to Connect to MySQL using ClearText Password
I'm trying to connect to an Amazon RDS MySQL instance.
We use generated passwords that expire from time to time. 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 MySQL Workbench, with the same connection string.
for record, the generated password is really big, almost 900 characters. maybe more sometimes, since it's generated. I thought it might be related to the size of the password string.
I'm using Driver ver 5.1.46
Any help is appreciated, since I'd really like to keep using my IntelliJ/DataGrip. Workbench is ok, but not my favorite.
Thanks a lot.
请先登录再写评论。
Hello, having the same problem and desperately looking for a solution to this. Did you ever figure it out?
Hello.
I don't have a solution and didn't get any help from jet brains either.
I went back to mysql workbench until I a solution comes up.
best Regards
Rafael.
Hi. I could not make this work either... Anyone?
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.