Access denied for user user@127.0.0.1 when hostname = localhost

3 posts
[expired user #7901]'s profile image [expired user #7901] posted 10 years ago in Creating a connection Permalink
I'm finding it impossible to connect using user@localhost. It seems to revert to user@127.0.0.1 for the actual connection.

Is there any way to force user@localhost rather than user@127.0.0.1?
3 posts
[expired user #7901]'s profile image [expired user #7901] posted 10 years ago Permalink
FYI, I'm running HeidiSQL on a Windows 7 machine.
87 posts
TTSneko's profile image TTSneko posted 10 years ago Permalink
You should check the settings of your server package ... "localhost" is an alias for the IP address 127.0.0.1, however it has to be supported (and set up) via the corresponding server package.

Neither MySQL/HeidiSQL are responsible for this.
3 posts
[expired user #7901]'s profile image [expired user #7901] posted 10 years ago Permalink
Got it. Thanks!

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