LinuxQuestions.org - Accessing MySQL from a PHP script (locally)

I just installed MySQL, Apache and PHP the way they installed it from "PHP - Fast and Easy Web Development" (kind of, RPM's didnt seem to work, so installing from source is what worked), i.e., For them to all work with each other (mostly just PHP needed additional parameters for configuration). MySQL works on its own, and I can access and parse my normal PHP scripts through Apache, but I used this code to try and access my MySQL database and it gave the error below:

PHP Code:




<? 
$connection = mysql_connect("localhost", "root", "mypassword") or die(mysql_error()); 
 
if ($connection) { 
    $msg = "it worked"; 
} 
 
?> 
 
<html> 
<head> 
<title>MySQL Connection</title> 
</head> 
<body> 
 
<? echo "$msg"; ?> 
 
</body> 
</html>

I get the following error message, and I'm not too sure what to make of it: Warning: mysql_connect(): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) in /usr/local/apache_1.3.29/htdocs/phpsql.php on line 2
Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

Hopefully some people have gone through this before and can help me out a little here, it would be much appreciated, I'm sitting here scratching my head...

Thanks alot!

:scratch: