[wp-hackers] Multisite Remote Database
wp-hackers at thecodecave.com
Mon Apr 11 21:40:05 UTC 2011
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.
More information about the wp-hackers