Forum Moderators: open

Message Too Old, No Replies

remotely connecting to a mysql database

         

jake66

2:49 am on May 5, 2007 (gmt 0)

10+ Year Member



I am in the process of moving from my current host, so I would like to remotely connect to my NEW database to avoid the downtime involved with the DNS propegation (that way any edits my users do to the database, are on the NEW database at the NEW host..)

I am able to connect to this database anywhere it seems, except for my actual host! (current)

This is the error I receive (after a 1-2 min lag):


Warning: mysql_connect(): Can't connect to MySQL server on '[new_server_ip]' (4) in /test.php line 2
I cannot connect to the database because: Can't connect to MySQL server on '[new_server_ip]' (4)

I have spoken to my new host about this and they have confirmed all of the settings are in place to allow me to remotely connect. And as I've said, I could easily connect via my localhost on my PC even.

Is this a server issue, or simply just a host issue?

I realize I am not supposed to name-drop here, but I feel that if the problem lies within the host's settings, someone reading this may know better than I.

Current host: Goddaddy (whom I'm moving from)

volatilegx

6:39 pm on May 6, 2007 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



It's been my experience that when you remotely connect to a database located on a hosting account, you need to allow the domain where the connection is being initiated from specifically. Normally, the only domains allowed to connect are the domain on which the database resides (possibly) and localhost. You need to add the domain you are connecting from to this list.