All of the advice on this board had been handy and this question recurs a lot...heres how I managed to change the root user password
I got the root user setup on mysql to work by punching in the password for my root level password on my iBook. For some reason it automatically had the password set to this. So when I typed
mysqladmin -u root -p password 'bla'
at the command line it asked
and heres where I entered my root level password for my iBook and thus changed the MySQL root password to 'bla'
it worked for me...
the connection string in php then becomes:
$dbh = mysql_connect( "localhost", "root", "bla" ) or die("not happening");