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
bug?: access denied when using ssh tunnel
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....
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....
Please login to leave a reply, or register at first.