Newbie installing MySQL on Linux RH7

Anon

I'm having a bit of trouble configuring the MySQL portion of the database on my Linux RH7 box. I get the following error, does anyone know what might be causing this?

I've developed the site on a Windows O/S and it works fine and I believe my database connection file (dblib.inc) is correct.

Warning: MySQL Connection Failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) in dblib.inc on line 8
Couldn't connect to MySQL

Can someone tell me where I can get some PHP/MySQL/Apache installation instructions on a Linux machine?

Thanks,
KABOOM

Anon

post dblib.inc

Anon

Here's my dblib.inc file.

<?PHP
$link;

function connectToDB()
{
global $link;
$db="test2";
$link=mysql_connect("localhost");
if(! $link)
die ("Couldn't connect to MySQL");
mysql_select_db($db, $link)
or die ("Couldn't open the $db database: ".mysql_error());
}

function checkPass ($login, $password)
{
global $link;
$result = mysql_query ("SELECT CUserName,CPassword FROM clients WHERE CUserName='$login'and CPassword='$password'", $link);
if(!$result)
{
die ("checkPass fatal error: ".mysql_error());
}

if(mysql_num_rows($result))
	{
	return mysql_fetch_array($result);
	}
return false;
}

connectToDB();
?>

[deleted]

http://www.xs4all.nl/~vinny/index.html#3

Anon

I'm still getting the same error after following the link Vincent provided.

Here's the line that it seems to chirping about:

$link=mysql_connect("localhost");

To see the whole dblib.inc file. Check out one of the other KABOOM messages.

Thanks,
KABOOM.

Anon

****** MANUAL *****
mysql_connect() establishes a connection to a MySQL server. All of the arguments are optional, and if they're missing, defaults are assumed ('localhost', user name of the user that owns the server process, empty password).

you shoule ALWAYS specify the username and password you want to use for security reasons... im just guessing that the the "user that owns the server process" is not listed in your user table.