Subject:   This should work...
Date:   2003-10-04 21:19:26
From:   anonymous2
Response to: didn't work for me...

First log into mysql, for me it's:

sudo /usr/local/mysql/bin/mysql -p

first you will be asked to enter your admin password, the one you use to install software. next you enter the current mysql root password.
Then to change your password, enter:

SET PASSWORD FOR root@localhost=PASSWORD('new_password');

Where new_password is your new password...