Access denied for user root when password and user is correct

chdonncha posted 3 months ago in General

I've had this issue for the past few days with no fixes I can find on the forum here.

The issue is the SSH tunnel to the host server seems to be able to establish a connection successfully but is rejected on connecting to the MYSQL database stating that access is denied for 'root'@''. I can confirm the credentials I'm using are correct as I've been able to successfully login using the same credentials on Putty and in terminal.

If anyone knows anything that may possibly help it'd be greatly appreciated!

ansgar posted 3 months ago

Is the local port on the "SSH tunnel" tab different to that one you are probably using for your local MySQL server installation? And on the same tab, is the SSH port correctly set?

chdonncha posted 3 months ago

Checked the port through the SQL server using SHOW GLOBAL VARIABLES LIKE 'PORT'; and returns the port of 3306 which I was trying to connect with. If I change any of the ports it returns an error saying it lost connection to the server rather than saying that access is denied.

chdonncha posted 3 months ago

Solved the problem. Port forwarding was granted to localhost which was confirmed at but also needed port forwarding granted with because it was converted from 'localhost' to automatically in Heidisql. Didn't think this would have been the problem but there we go!

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