Hi folks, I have two servers (SERVER1 and SERVER2), that are Windows 2008 R2 boxes. I'm running SQLyog on SERVER1, and am trying to get database synchronization to SERVER2. When I instruct SERVER1 SQLyog to connect to SERVER2, I get this: SERVER1 is not allowed to connect to this MySQL server. I found this, but wanted to verify that was all I needed to do to enable this. Error 1130, remote connecting access denied. - Dev Shed These servers are both within my LAN.
Yea, you'll need to enable remote connections on the servers so that they can talk to each other. Correct me if I'm wrong though, I suck at explaining things and all lol.
There are a couple ways to do this, the thread you linked to will work. I'm a Linux guy by nature, but you might also want to make sure that the Windows firewall is allowing the server to connect.
