mysql_connect()

[Anon]

this is weird. mysql works, i can connect from a command line.

but this code produces the output below:
<?
$link = mysql_connect("localhost", "root", "rootpassword");
print ($link);
?>

Warning: MySQL Connection Failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) in /usr/local/apache/htdocs/md5.php on line 3

does anybody know what I can check to resolve this?
thanks

[Anon]

okay, so i found that the socket file is in /var/lib/mysql/mysql.sock
does anybody know how to change the config in php to make it point to the right file?

[cvincent]

either make a symbolic link (ln -s /var/lib/mysql/mysql.sock /tmp/mysql.sock) or edit/add the setting "mysql.default_socket = /tmp/mysql.sock" in the php.ini and restart apache.

-Chris

[Anon]

kick ass, thanks!