distal-attribute
distal-attribute
distal-attribute
distal-attribute

HeidiSQL SSH

abnormality posted 2 years ago in General
Hello guys, I've tried connecting to my SQL server using HeidiSQL. The SQL server only accepts connections from localhost so I have to SSH into it and then connect. When I connect normally using Putty and then mysql -h 127.0.0.1 -u -p it works perfectly. My steps:

When trying to use HeidiSQL I set network type to MySQL(SSH TUNNEL).
(ssh tunnel tab)Set plink location, set ssh host and port, set ssh username and password, leave the rest as is.
(settings tab)hostname/ip i've tried putting 127.0.0.1 and host of sql server. user and password I fill with SQL credentials and I'm getting errors that it says it can't connect to localhost. Any help? thank you!
ansgar posted 2 years ago
In the settings tab, do not use 127.0.0.1, but the real host ip/name. In the SSH tunnel tab, do not enter any ip/host.

Then, ensure you have plink.exe specified, and it's not red (= can't find the path).
abnormality posted 2 years ago
I'm getting host 'xxxxx' is not allowed to connect to this MySQL server.
ansgar posted 2 years ago
Can you post the plink command line here, which HeidiSQL creates? Be sure the password is obscured. To see the command line, you will need one successful connection to any server, and the SQL log visible. Then, click File > Session manager, and try the SSH connection. The plink.exe command line should be visible in the SQL log afterwards.
abnormality posted 2 years ago
Worked great now. I think it was because of my firewall. Although I CLEARLY stated that I wanted to allow it, that seemed to be the problem. Thank you!
ansgar posted 2 years ago
Super! Thanks for the feedback.

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