bug?: access denied when using ssh tunnel

[expired user #5253]'s profile image [expired user #5253] posted 13 years ago in General Permalink
Hi all,

I am connecting trough a SSH tunnel (host-A)
to a mysql on host-B (host-B is not localhost)

I can connect just fine.
I even get the database list, tables list.
When i try to browse the table fields, table data or write my own query i get this error:
/* SQL Error (1045): Access denied for user 'MYUSER'@'localhost' (using password: YES) */

I only have access from host-A to that mysql server.
I should be authed on host-B with 'MYUSER'@'host-A' , not 'MYUSER'@'localhost' ...
How can i do this ?


In the session manager:
Settings tab:
-network type : SSH tunnel
-hostname: host-B
(all the logins etc)

and in the SSH Tunnel tab i have:
plink location
the ssh host is host-A
As a login im using a private key

[expired user #5253]'s profile image [expired user #5253] posted 13 years ago Permalink
bump
ansgar's profile image ansgar posted 13 years ago Permalink
Don't know what's going on exactly. If you can connect everything should work except those things for which you do not have some privilege.
[expired user #5253]'s profile image [expired user #5253] posted 13 years ago Permalink
the error given is
" Access denied for user 'MYUSER'@'localhost' "

The user has all the privileges but not from the host "localhost" but from "host-A" from wich i am connecting ...
ansgar's profile image ansgar posted 13 years ago Permalink
Got that. Only I have no clue what is causing this. Is the connection still alive in the moment when you get that error?
[expired user #5253]'s profile image [expired user #5253] posted 13 years ago Permalink
Dont think im doing something wrong, i attached a
censured screenshot.
http://i53.tinypic.com/25utxeb.png
SSH on alex@aff2.c1 (privatekey) to mysql to affiliates@sqllb1.c1:3308
I triple x10 checked the password ..

I dont even know how its possible for mysql to give
access denied on localhost on a user wich is connecting from another host....
[expired user #5253]'s profile image [expired user #5253] posted 13 years ago Permalink
Same issue as in:
http://www.heidisql.com/forum.php?t=7767#p7770

increased the timeout and ok.

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