[issue] Access denied for db user

[expired user #8810]'s profile image [expired user #8810] posted 9 years ago in General Permalink
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
3 attachment(s):
  • 2015-03-30-15_46_02-heidisql_Session-manager
  • 2015-03-30-15_47_55-Session-manager
  • 2015-03-30-15_49_18-Session-manager
ansgar's profile image ansgar posted 9 years ago Permalink
Try to use a different local port in the "SSH tunnel" tab. For example 3307. And be sure not to use a port which is used by another ssh tunnel on your computer.
[expired user #8810]'s profile image [expired user #8810] posted 9 years ago Permalink
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.
[expired user #8810]'s profile image [expired user #8810] posted 9 years ago Permalink
FWIW I have tried connecting to the db through MySQL workbench and receive the same access denied error.

Do you have any idea why I would be able to connect to the db on another machine/client, but not this one?

Thanks.
ansgar's profile image ansgar posted 9 years ago Permalink
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?
[expired user #8810]'s profile image [expired user #8810] posted 9 years ago Permalink
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.
[expired user #8810]'s profile image [expired user #8810] posted 9 years ago Permalink
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.

Please login to leave a reply, or register at first.