Unable to connect

cmccomas

What are the most likely causes for this error?

Coming from this line of code:

// open database connection
$connection = mysql_connect($host, $user, $pass) or die ("Unable to connect!");

With the following error message:

Warning: mysql_connect(): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) in /hsphere/local/home/nova2/novaflow.net/site/main.php on line 75
Unable to connect!

dalecosp

One or more variable(s) have no value
Incorrect host
User has no rights
Bad password

Try to login to the monitor program and see what response you get?

cmccomas

should the host be what? "localhost"

cmccomas

Tried it all, still won't work. I logged into the control panel and checked the host, user, pass, etc.

dalecosp

If the database server and the webserver are the same physical computer, yes.

cmccomas

okay, they aren't i have another site on the same server and all and it is working 100% fine. it being all the PHP.

cmccomas

Changed passwords and usernames and got a different error, so it's not there.

dalecosp

Originally posted by cmccomas
Unable to connect via /tmp/mysql.sock ....

That's almost always a "server is off" error....dunno why you'd be seeing it if it's running, though...