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.

Can't connect after restart by HeidiSQL

mRc0's profile image mRc0 posted 1 month ago in Creating a connection Permalink

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

ansgar's profile image ansgar posted 1 month ago Permalink

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?

mRc0's profile image mRc0 posted 4 weeks ago Permalink

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

Jayden's profile image Jayden posted 4 weeks ago Permalink

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.

mRc0's profile image mRc0 posted 3 weeks ago Permalink

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.

Jayden's profile image Jayden posted 3 weeks ago Permalink

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

Jayden's profile image Jayden posted 3 weeks ago Permalink

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

mRc0's profile image mRc0 posted 3 weeks ago Permalink

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.

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




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.