I'm not sure if this is a MySQL, PHP or Apache problem and I need some help. I'm running all of the following on my local machine.

I've typed the code and also downloaded the code from http://web.wrox.com/0764557440/bpamweb.zip but keep getting the following error:

Warning: mysql_connect(): Can't connect to MySQL server on 'localhost' (10061) in C:\Program Files\Apache Group\Apache2\test\createmovie.php on line 4

Line 4 is:
$connect = mysql_connect("localhost", "root", "*******") or
     die ("Hey loser, check your server connection.");

I'm able to login into the MySQL console as root with this password. The only module I could not add to Apache was "mod_php4.c" -- the service would not start.

I've spent most of my time on MySQL, but not sure if this is it. I've re-installed MySQL a few times to see if this would correct it.

Any suggestions?

I got it to work! It must have been the win.ini file.

After restalling MySQL, starting winmysqladmin.exe asks for a username and password. This time I used the root id and password and it worked.

I haven't seen any documentation that states you need to use root with winmysqladmin.

Ah, that was a day well spent.