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 3 months 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 3 months 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 3 months 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 2 months 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 2 months 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 2 months 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 2 months 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 2 months 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.

ClarkeyBoy1987's profile image ClarkeyBoy1987 posted 2 months ago Permalink

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?

ClarkeyBoy1987's profile image ClarkeyBoy1987 posted 1 month ago Permalink

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

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.