Problem with mysql and connetion to it using php

[email protected] (Robert Courtney)
Newsgroups php.install
Message-ID <[email protected]>
Hi all,

I am new to this newsgroup and have a question about using php with 
mysql. I have installed mysql 4.1.7 and php 5.0.2 with apache2 2.0.52. 
All the services come up ok work. I can execute php files with apache2 
and I can bring up mysql and query the database.

My problem is I cannot connect to the mysql database using php 5.0.2 
when I test with a php file.

<?php
$username = "root";
$password = "bobby";
$hostname = "localhost";	
$dbh = mysql_connect($hostname, $username, $password)
	or die("Unable to connect to MySQL");
print "Connected to MySQL<br>";
// you're going to do lots more here soon
mysql_close($dbh);
?>

I get the erorr unable to connec to mysql from the php script. I don't 
know why I cannot connect because root does exist and I have the 
password bobby on it.

I have heard that mysql and php do not work well with 41 char password 
and should be set to the old password lenght of 16. I have tried that I 
don't seem to connect. Does anyone have any ideas to correct this problem?

What is the best way to look at errors?

Thanks,

Bob Courtney
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.