mySQL connection.

[khaine]

I am having problems with connections to mysql the error is Warning: MySQL Connection Failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111) in /usr/local/apache/htdocs/comproom/php/db.php on line 3

the program is very simple.

<?php
$conn=mysql_connect("localhost", "user", "password") or die("cannot connect");
echo "connection made";
?>

any ideas?

[Anon]

Maybe it has to do with the rights. Check whether the user of the webserver is able to create new files in /tmp/
And look whether the file mysql.sock is created.

[khaine]

theres no mysql.sock how do I create that?? the permissions seem good though.

[khaine]

Its ok I sorted it. Clean reinstall solved the problem.

[Anon]

🙂

BTW: YOu dont have to create this file, its created automatically by the server.