MyODBC cannot connect to remote MySQL database
Posted on 2004-11-11
Hi there. I have a two servers connected to the net, and a MySQL server running on a LAN at my office. The LAN is protected by a firewall which has port 3306 forwarded to the MySQL machine.
One of the computers on the net can access the MySQL data, and one cannot even connect to it.
I try from my house and various other computers and they all work fine. Its just one server that cannot access it.
The one that doesn't work is a NT4 Server, but it used to be fine, and it used to "see" the data until one day the mysql server failed, and since it has been rebuilt it cannot access it.
Does anyone have any ideas of why this one machine cannot view it? It can ping the router that the mysql server is connected to, but nothing other than that.