Issue with Connecting to MySQL Server

gregbowers's profile image gregbowers posted 3 months ago in General Permalink

Hello

I'm facing an error while trying to connect to my MySQL server using HeidiSQL and need some help in troubleshooting.

When trying to connect to my MySQL server using HeidiSQL, I receive the error message: "Access denied for user 'username'@'host' (using password: YES)". This error prevents me from establishing a connection to the server and accessing my databases.

I've double-checked the credentials (username, password, and host) multiple times to ensure they are correct. I've verified that the MySQL server is running and accessible from other clients. but, I'm still unable to connect using HeidiSQL.

I've tried resetting the MySQL user password, granting additional privileges to the user, and verifying the MySQL server's configuration settings. However, issue remains unresolved.

I'm asking for guidance on how to resolve this "Access Denied" error when connecting to MySQL using HeidiSQL. Any suggestions would be greatly appreciated.

Thank you for your help!

Thank you gregbowers

ansgar's profile image ansgar posted 3 months ago Permalink

Watch out for the hostname in the error message:

Access denied for user 'username'@'host' ...

This is the clients hostname, from which you are about to connect, and where HeidiSQL runs. It has to match to a row in the mysql.user table.

I recommend having a look at that table. The "Host" column must match the one from your client. For example if the row's Host is "localhost", you can only connect from within the same machine where the MySQL server runs.

You can open the user row for a specific IP address, or to any host with a percent wildcard:

Description

gregbowers's profile image gregbowers posted 3 months ago Permalink

issue resolved . Thank you

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