[wp-hackers] Multisite Remote Database

[Brian Layman]

On 4/11/2011 2:58 PM, Andy Charrington wrote:
> I am trying to set up a test environment for a multisite install and figured
> that the most realistic tests would be when done with actual data from from
> the target site. So...
> Would somebody mind explaining and/or pointing me in the right direction??

Leaving port 3306 wide open is generally a bad idea.  You'll eventually 
be hacked or have a slow mysql server due to all the servers out there 
continuously trying passwords.

What you are trying to do will work. IF you really want to do this test, 
figure out your hostgator IP address and then contact wired tree and 
then can setup a iptables rule to open 3306 for only that server on your 
vps.  Additionally you'll need to make sure that you are able to make 
the out bound connection from the hostgator side.  It is likely blocked 
by default.  If you have ssh access on your host gator account, I would 
use mysql from the command line to make sure that part is working before 
trying to diagnose more wide ranging issues.

Beyond that you'll need to post to the support forums for help with a 
better definition of what you mean by an infinite loop...

Hope that helped.
-- 

Brian Layman