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!