Can't connect to one of two remote Databases.
So I have two Maria DBs. I've succesfully connected to one. But cannot do the same to another.
I get such an error:
if I set `passwordCharacterEncoding` to true, I get following error:
the only difference between these 2 databases are login credentials. The first database with shorter (8-10 characters) password connects succesfully, this second with approx. 30 characters password doesn't connect.
Have googled but didn't find anything suitable to solve this problem. If you need additional information, be my guest!
Thank you.
Please sign in to leave a comment.
According to the documentation, "passwordCharacterEncoding" parameter should have a specific encoding as a value, not just "true", please check:
https://mariadb.com/kb/en/about-mariadb-connector-j/#infrequently-used-parameters
Thank you for clarification. But which encoding should I use? I set it to "utf8" and get this error:
[08][-1] Could not connect to address=(host=localhost)(port=3306)(type=master) : Connection refused: connect
java.net.ConnectException: Connection refused: connect.
Unfortunately, "Connection refused" is a way too generic message here. By the way, is there any chance that your password has any special characters or national non-Latin symbols?
I see, ok, thanks.
Yes, my password has some of these -> &%/$'#+-;
A little bit obvious question but nonetheless, could you please confirm that this password works fine with this SQL server apart from the IDE, for instance, with the MySQL CLI?
yeah, the password is valid
Thanks for checking.
Probably, logs could tell more about the exact error message. Would it be possible to collect these (Help > Collect Logs) and submit a support request?