Remote Connection Help

I had this working but when I changed my IP the proces stopped working.

2 servers, 1 at a host and 1 local (I am the admin).

The code runs on the hosted server. I need to do a remote connect to the local server and insert rows. However, this is no longer working.

The following is in the user table for the particular user name which I use to access the local server. Host = %

Not sure why this is happening. Here is my connection string:

$result=mysql_connect("123.123.456.789", "user", "pw") or die ('I
cannot connect to the database.');

mysql_select_db("db_name");

Did you change the 'host' value for this server after the IP changed?

If so, did you do a 'flush privileges' ?

-- Jason

I changed the IP but did not perform a flush privileges. I will try this tonight when I get home.

Thank you.

Ned

The flush privileges did not seem to work. Here is the error I'm getting:

Warning: Can't connect to MySQL server on '12.345.678.900' (110)

In the user table do I need to have my IP address in the Host field?

Ned

Using a PC on the home network I was able to connect. Copying the code to the hosted site I am unable to connect to MySQL.

The code is exactly the same. At a loss and would love some insight into this.

Ned

Maybe you have the IP blocked at a firewall somewhere? Or perhaps in /etc/hosts.deny ?

-- Jason