Hi all,
my client has a Red Hat box running MySQL 5. I can connect to the MySQL server using Putty over the VPN connection they have set up for me. I am trying to create a remote_admin account so that I can use SQLYog to administer the database from my Windows box which is connected to the VPN. This is a temporary set up for Development.

So I log in as the MySQL root user and do the following:

mysql> GRANT ALL ON fieldworkx.* TO 'remote_admin'@'<MY_IP_NUMBER>';
mysql> FLUSH PRIVILEGES;

The queries run fine. If I check the records in the User, Host and DB tables everything looks good. But I get denied when trying to connect using SQLYog.

In addition Apache and PHP are running on the same server. I set up a user for the PHP application and I also get denied when trying to run the app. The web_root user's host was set to localhost.

Thank in advance.