Error 1045 For Ssh Tunneling — Probably A Local Port Issue.

[Linda]

Hi,

I am trying to get the trial of the latest SQLYog Enterprise version to work with SSH tunneling, to see if it will do what I need, but I am getting error 1045 even though I have verified that the ssh username, password, server and port are correct. The error message also notes that access is denied for @, so its definitely trying to connect through the localhost and not from my remove machine.

I am guessing at this stage that the issue is the local port. I am behind a software firewall as well as a hardware firewall, and I would guess this means I need to so some setup to make this work? I have no clue what, however. Any suggestions? 🙂

[peterlaursen]

I do noit think this is a firewall issue. The 1045 error is a MySQL server error, and an authentication error with mySQL (not with the SSH daemon).

Are you sure that you use the MYSQL username and password on ther server tab?

[Linda]

peterlaursen wrote on Oct 19 2006, 06:07 AM:

I do noit think this is a firewall issue. The 1045 error is a MySQL server error, and an authentication error with mySQL (not with the SSH daemon).

Are you sure that you use the MYSQL username and password on ther server tab?

I have checked and double checked the mySQL username and password, and they are exactly the same that I use with other applications that do manage to connect.

[peterlaursen]

hmmm … is SSH and MySQL installed on the same machine?

[Linda]

Yes, I can connect to the SSH via PuTTY without any problem, and from there I am able to get to the mySQL using mysql -p and then giving the password.

Edited add: The one thing I do find a bit odd is how it gives the error message, as it says access denied for user 'username'@'mysql host address', including those single quotes.

[peterlaursen]

'username'@'mysql host address'

the quotes are normal in the MySQL server error message. But is it LITERALLY 'mysql host address'? It should simply be 'localhost'

what is 'latest SQLyog version'? Numbers please!

I suggest you create a ticket and attach screenshots of you connections dialogue (both tabs)

[Linda]

Sorry, no, not literally 'mysql host address'. But it is not saying 'locahost', no. Its giving the address I put in as the ssh server and mysql server address.

Version is 5.19

[Linda]

Just after I submitted a ticket (have now closed and updated it), I saw the reference to http://webyog.com/faq/16_66_en.html in another question on the forum. Well, that solved it, as the problem was that I still had the MySQL Host Address to the address to the remove server, as I had been using before I added the SSH tunneling. Changing that to 'localhost' was what was needed.

[Author]

Posts