Hello,
I am running HeidiSQL on a Win8 machine. I am attempting to connect to a MariaDB database (Moodle). The connection protocol is MySQL (SSH Tunnel). I think that I have the settings correct (screenshots attached). When ever I attempt to connect, I receive an access denied message for the db user. The user has all privileges. I can confirm that the user accounts are correct.
I can connect to the db using another computer and client (Mac, Sequel Pro).
Does anyone have any idea about why I am receiving the access denied error?
Thanks,
Jedidiah
[issue] Access denied for db user
Thank you for your help.
I have tried a number of different ports( 3307, 3000, 3724). All resulted in access denied.
I don't know if it matters or helps, but I tried an old password for this user and was able to access the Information_schema tables. I was not able to access the Moodle tables though.
I have tried a number of different ports( 3307, 3000, 3724). All resulted in access denied.
I don't know if it matters or helps, but I tried an old password for this user and was able to access the Information_schema tables. I was not able to access the Moodle tables though.
On TCP/IP connections this is normally caused by the user/host combination which must exactly match the one on the server's mysql.user table. But on SSH connections you are connecting to a different machine anyway before actually connecting to MySQL, so the user/host should match the right one. Except for a situation in which the SSH tunnel connects to a third machine (not your local computer and not the MySQL server machine). Is that the case for you?
I think the answer is 'no'. We are trying to connect from a client to the server. There is no other third computer involved.
I believe that the host, the user, and the password are correct. The issue is not that we cannot connect to the server. We can connect, but it fails. The handshaking is not working between the client and the server.
I believe that the host, the user, and the password are correct. The issue is not that we cannot connect to the server. We can connect, but it fails. The handshaking is not working between the client and the server.
Hello, this is still an issue. I have been unable to get the client to access the db. I have also tried another client (MySQL Workbench) and the connection fails also.
My server admin confirmed that the db user and password are correct and can log in to the db. Any help is greatly appreciated.
My server admin confirmed that the db user and password are correct and can log in to the db. Any help is greatly appreciated.
Please login to leave a reply, or register at first.