Connection through SSH Tunnel fails

[expired user #5903]'s profile image [expired user #5903] posted 13 years ago in General Permalink
It fails with an error of
SQL Error (1045): Access denied for user 'root'@'localhost' (using password: YES)

It's impossible that is wrong the user, password or host because they work fine.
Also the SSH data is correct

I can do it manually to connect to mysql, so why cannot HeidiSQL ?

After looking for solutions.. people says to extend the Timeout.. but this seems to have been removed from the GUI ?

Then I found this blog post http://www.turnkeylinux.org/blog/slow-ssh

And I follow those 2 steps:
add "UseDNS no" to /etc/ssh/sshd_config
add the client's net address to the server's /etc/hosts

The ssh prompt became much faster.
And now HeidiSQL can connect also , yayy!!

So please, could you bring back a timeout setting ? for others who don't have a fast ssh connection (or because they can't follow my fix because permission issues it in the ssh server)

Thanks for HeidiSQL!smile

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