Can't connect after restart by HeidiSQL

Hi there,

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".

Sounds strange. The Windows Firewall should also not be the cause here, or? I was just thinking your first connect goes through some existing SSH tunnel, to a different server, or something like that.

Did you try to connect twice via HeidiSQL, so whether the second connect after the fail is successful?

Hi, no tunnel involved, I'm working directly on the machine. I can try to login as often as I like, it will only work after I logged in by shell (or another application).

to mRc0, Hi, I am an expert person at using the Heidisql app let, me help you and then perhaps the problem can be resolved. Try logging out of your Heidisql app and then restarting your Heidisql app and then logging back in to your Heidisql app again.

Hi Jayden, logging out, closing application and restart does not help: "Access denied..." It seems like only Heidi has this problem. The webapp setup accessing the database has no problems.

Yes, let me work with you so that we can resolve this issue, give me one hour and I will be back to help you out. thanks, mate

From Jayden To mRc0:Try again signing out of your account, restarting your device, and then signing back in to your heidisql account again

Hi, this doesn't help. I restarted the whole server several times but no change :( At first I thought might be kind of problem with 127.0.0.1 <-> localhost, but it happens for users with mysql.user.Host = localhost and mysql.user.Host = % and the webapp - as mentionend before - has no problems using one of the users on accessing the database.

I was about to report this issue too. I am running MySQL on my local machine and every time I restart Windows, I cannot log in as 'root'@'localhost' in HeidiSQL. I know the password to be correct as I keep it saved. However if I start MySQL Workbench and log in there, the same connection then works in HeidiSQL. I much prefer this due to the dark colour scheme, but it's a pain to have to start MySQL Workbench in order to use it (or even just having to keep it installed - I'd much rather be rid of Workbench to be honest).

Any suggestions on how to fix this?

Hi,

Can this please be fixed? It is getting really frustrating to have to open Workbench (and even keep it installed, taking up space on my laptop) before I can log into HeidiSQL. Thanks.

Kind regards, Richard