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'@'127.0.0.1'. 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!