dragon2611 posted 1 year ago in Creating a connection

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.

garreh posted 10 months ago

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.