I’m having issues using SQLYog on my PC to connect to my server. I am using the exact same settings on my Mac using the FREE Sequel PRO and it works without any issue.
I am able to connect through SSH via SQLYog but when it tries to connect to MYSQL it throws back an ERROR NO. 1045 Access denied for user ‘root’@’localhost’ (using password: YES)
The password IS correct. I noticed if I log into my server via terminal and try to access mysql by doing:
mysql -u root@localhost -p
I get the same error message response. I usually connect to mysql server by doing this:
mysql -u root -p
So how do I tell sqlyog to NOT include the @localhost, which I assume it’s doing. I am using localhost in the “MySQL Host Address” field, so I assume that’s the issue. However, i can’t leave this field blank.
On Sequel Pro, I am actually using the server’s public IP address for the mysql host address. Anyway, that tool is working. I would just like to get this working from my PC though.