Tip: Multiple SSH tunnel connections.

Hey,

I couldn't understand why I kept getting access denied errors when connecting to a 2nd server via an SSH tunnel. I just realised that it's because both connections were using the same local port (3307). So if you want to use multiple tunnel connections, remember to use a different local port for each one.

It may seem obvious, but it's always the simple stuff that results in lots of wasted time.

HTH,

Glen.

PS. It may be a good idea for HeidiSQL to warn you when port is in use.

This helped me out, 3 years later!

I was looking at my mysql logs, wondering why I wasn't getting any access denied errors. Agree on the warning part.

Seems so obvious, yet this was a problem for me for a whole year. I just worked around it by only having one SSH connection open at a time. Never thought to search for a solution until today.

So yeah, thanks!

Hi, Thanks for your tip.

I wonder why this happen. I use HeidiSql over the years to manage MySql server through SSH Tunnelling without any problem.
Recently after update HeidiSQL to version 9(9.1) I realized I could not connect to more than one server at the same time. I thought this is a bug for new version; but it seams it was my mistake which never use two ssh tunnel at same time :P

By the way I agree with @darkangel that this can be new feature to warn when create new connection with the same local port.

Thanks for your help.

I created a post on feature request for this:

SSH Tunnelling connection local port existence warning