can't connect to mysql server through php

[dtra]

hi all
i'm using the sitepoint book and installed php on iis
but i'm having problems with this line

prompt

$dbConn = @mysql_connect('localhost', 'root', 'mypassword');
    if (!$dbConn) {
        echo('<p>Unable to connect to the database server at this time.</p>');
        exit();
    } 

name is definitely localhost,
root, and password are definitely right,
i can connect in the command prompt and edit and stuff
but i always get the error message
i've tried removing the @ symbol, but i still get my own message
i installed php and mysql exactly the same as in the book
in different directories but i don't think that would be the problem

anyone know what could be wrong
i can do other php, just can't connect to the mysql server

thanks

[Lats]

Modify the first line to display the error being generated.

$dbConn = @mysql_connect('localhost', 'root', 'mypassword') or die(mysql_error()); 

Having the error code will assist in determining the problem.

[dtra]

thanks for that
i didn't know how to write out the error
i'm at work at the moment, but i'll try tonight
and post the message then
thanks again

[dtra]

Unknown MySQL Server Host 'localhost' (11001)
but i have mysql control centre and it connects to localhost

and i connect in the cmd prompt and it says localhost

[Lats]

Ummm, it certainly looks like the normal way of connecting to a db.

Doing a google on that error number wasn't very helpful

[dtra]

i buy this book
and it turns out to be useless
it's all good and well that i can read through
but if i can't use it practically
then it's just not useful

[Lats]

It works well for me on my local linux box, and my live server, so possibly a configuration problem??

[dtra]

the only difference from the book i have
is where i installed mysql and php
but i changed the my.ini file to match
i installed mysql on my personal drive
where i have iis and php running from
do you think i should try uninstalling mysql
and reinstalling it into the program files dir?

oh and mysql-nt.exe is definitely running

[dtra]

very strange
now for some reason it works
i checked it on my other computer over the network
and the page worked, and now for some reason it
will connect to mysql, i hope it's not because i'm
connected to the internet
cos i'm on dialup, and i don't want to connect
everytime i want to check something