Cannot connect remotely to MySQL database
Posted on 2004-09-07
OK on to the next hurdle. I have been wrestling with this for hours. I have installed MySQL 4.0 on Windows Server 2003. I have created a user and granted that user remote permissions to for the SQL server. I am now trying to connect to the MySQL server from MySQL Control Center. I cannot connect. It constantly tells me "Cannot connect to MySQL Server on <IP Address> (10060). I set-up the account to connect as
The MySQL server is on the same Web server as the Website but I do not think that should matter from what I have read. I have an extra IP and I configured to Bind Address to that IP. The service starts fine on the Server and I am able to see the two databases (test and MySQL) when logged in as the root in the INI file.
I am wondering if the 3306 port is blocked and how I can unblock it if that is the problem. If anyone knows the answer please give me a shout.