I set up an MySQL8 Server and Database on a Windows system. Accessing the mysql by shell works (that's why the following is definitely no wrong password issue). So now I would like to access the database by Heidi, and here starts the problem:
Each time I restart the server and want to access the database I'm getting the error "Access denied for user 'xxx'@'localhost' (using password:YES)".
But if I log in first by shell (and logout again) and start Heidi afterwards, it is running perfectly. I just wouldn't like to have to do that all the time. I guessed this might have to do something with the connection setup for hostname (localhost / 127.0.0.1), but this behaviour is the same for all database users, no matter if 'Host' at mysql.user says "%" or "localhost".