[expired user #10992]'s profile image [expired user #10992] posted 7 years ago in Creating a connection Permalink

Any chance of supporting sending user@localhost instead of user@ when connecting to MYSQL via an SSH tunnel as some versions of Mysql treats them differently and I've had some instances where user@localhost exists but user@ doesn't and I have to go in with the command line utilities and at as an allowed host before heidisql will connect.

[expired user #11252]'s profile image [expired user #11252] posted 6 years ago Permalink

I'm having the same problem.

According to the MySQL docs - it treats connections from and localhost completely differently - with it uses a TCP connection and localhost uses a unix socket (much faster) - also with Grant permissions / privileges they are not equal either.

If you set "localhost" in your Heidi settings, it will automatically change it to - it should obey whatever you've set imo. Very frustrating

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