Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.

Bug with basic authentication.

bob's profile image bob posted 4 years ago in Creating a connection Permalink
Hostname / IP defaults to 127.0.0.1, I rewrote it to localhost. However, it seems it is trying to be smart, knowing that localhost = 127.0.0.1 - so it tries to auth me with MySQL as `user@127.0.0.1` which MySQL promptly rejects, as most auth rows like this use `user@localhost`.
bob's profile image bob posted 4 years ago Permalink
just double checked, this is totally a problem. i needs to explicitly use what i tell it in the hostname field. in this particular case i was able to get around it by adding a line for `user@127.0.0.1` via GRANT ALL PRIVILEGES but that is not always going to be the case

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