I've been successfully using SQLyog for some time to connect to & update a MySQL database hosted by my ISP. However I now want to connect to a MySQL database hosted elsewhere and I'm not getting very far!
I've allowed remote access to the database from my (static) IP address and (according to a reply on the Host's forum) I seem to have the 'MySQL Host Address' and username/password set-up OK. But when I try to connect, I get: Error 1045: Access denied for user 'password' @ 'zillion.plus.com' (Using password: YES).
From that it looks rather like SQLyog is ADDING the @ 'zillion.plus.com' bit to the password I've entered; but maybe I'm misinterpreting this. Either way, has anyone any ideas what I'm doing wrong (or not doing at all!)?