I'm having a huge problem getting PHP on IIS to access the MySQL server (running on the same server). I get a 10061 error when trying to issue a simple connect:
Warning: mysql_connect(): Can't connect to MySQL server on 'xxx.xxx.xxx.xxx' (10061)
Username, password and IP are correct - and the MySQL server is actually running and working perfectly. I can access it just fine from the same server using ASP or my home Linux box running PHP 4.3.8 on Apache. Let me clarify that: The EXACT same mysql_connect command works from my (remote) Linux/Apache box, but not on the (local) IIS server.
The server I'm having trouble with is running IIS, PHP 4.4.0 and MySQL 4.0.22-nt. PHP is running in CGI mode and reports MySQL Client API version 3.23.49.
Anyone have a clue what my problem could be?
I've just about googled myself to death on this issue. It seems that basically the only advice I've found is that people need to make sure MySQL is running (it is), that the username/password is correct (it is), that the correct port is being tried (everything at default, so it is) and that a firewall isn't blocking the request (it isn't).
Any help would be greatly appreciated.
Sincerely,
fyo
