Is mySQL on the same machine where the script is running? Is it a Linux/Unix machine? The way you're using it, it seems like you're trying to make the connection to the local machine, and mysql probably isn't running.

I used mySQLpp as opposed to your mysql module. Have a look at it. It works similar to mysql. Also read through the docs. I know that's not always the answer you're looking for, but the answers you're looking for are in there.

cheers...Phil