mysql problems with Windows installer version of php

cdpapoulias

Hello all. I am very frustrated here. I installed PHP (Windows installer version, with mysql enabled, current version) on WinXP Pro - PWS/IIS5.1.

Without touching php.ini file (sans user and passwd), I tried to connect likethis : $link = mysql_connect("localhost", "cdp", "cdp")
or die("<br><br>Could not connect: " . mysql_error());

I unfortunately got an error like this: Warning: mysql_connect(): Can't connect to MySQL server on '192.168.1.100' (10061) in c:\inetpub\wwwroot\p\index.php on line 11

Since the mysql libraries are in php, I can't test anything using the console as I normally do in linux. I did do a netstat -a and did not see anything on 3306 (even when hard coded). I tried hardcoding different hostnames (localhost, 127.0.0.1, 192.168.1.100, machinename, etc) to no avail. I tried hardcoding the port to no avail.

Any ideas out there? This is really frustrating and I need to make this work!! Thanks to all.

TheIceman5

IIS - Microsoft = CRAP!! what else can u say. never heard a good thing about IIS, apache is the way to go. although this probably aint this particular problem.

cdpapoulias

TheIceman5,

Trust me I know. All other servers I have are running under either Solaris or Linux with Apache. But in this case, alas, I must use this combo. But thanks for contribution 🙂

Dinos

Norman_Graham

Do you absolutely have to use PWS/IIS? You can easily run Apache on Windows. I have Apache/PHP/MySQL on Win98SE and a friend of mine has the same set-up on WinXP Pro.

As for the MySQL thing, I know that you have to specify MySQL to run as a service on Win2K and XP - my friend had problems with this - but it can and will work.

Sorry not to have more details

Norm

cdpapoulias

It isn't a super-strict requirement, I was just trying to minimize the amount of new software installed on my machine, its already got tons of stuff (P4/1.6 512 ram but still). I'll probably just install apache.

The only thing is -- I just have this thing that I must get IIS - PHP/MySQL working...just for the sake of knowing how.

I know MySQL is run as service on Win2k and XP -- but with the MySQL stuff loaded directly into PHP, there are no separate binaries.

Thanks for the reply!

Norman_Graham

Fair enough - it can certainly be done. Try these links for some tips:

http://www.bitzenbytes.com/101/n111-websrv.htm
http://www.hotscripts.com/PHP/Tips_and_Tutorials/Installing_PHP
http://www.lennon-fan.com/tutz/PHP_n_IIS.htm

HTH

Norm