Article:
  Apache Web-Serving With Mac OS X, Part 5
Subject:   MySQL root user password explaination
Date:   2004-10-16 23:40:42
From:   joe@collabornet.org
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


Password:


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");