Getting The specified database user/password combination is rejected: [HY000][1045] Access denied for user: when attempting connection to MariaDB with SSH tunnel
We have a database that requires that we log into a system to then gain access. In 2018.3, I was able to create new data source, enter the database information on the General tab and then enter information for the system to ssh to on the SSH/SSL tab. I provided the user names and passwords. This worked fine.
Recently upgraded to 2019.1.3 and the data on the tabs has changed a bit. Now when I attempt to log in, it gives me the error:
The specified database user/password combination is rejected: [HY000][1045] Access denied for user: '@mysystem' (Using password: NO)
Remember, I provided the user name and password to the database server. It is dropping off the user name and thinks that I am trying to log in with "no" password. On this error modal, it then prompts me for the user password again.. but the user name is already populated with the user name I have configured. If I type in the password and click OK button, same error.
I have not changes any of the other settings other than those two tabs. Any ideas or suggestions?
Please sign in to leave a comment.
@Randy Winsinger,
Could you try
?
So '@mysystem' is not your username? Please provide `idea.log` it contains more info about connection process. The problem is with db authorization, not SSH. And looks like SSH does not matter here at all. Just to be sure: are you typing db credentials? :)