Quoting Nate Carlson (natecars at real-time.com):
> Are you just hitting enter for the password? That should work fine..

   bash# mysql -u root mysql
   mysql> UPDATE user SET Password=PASSWORD ('new_password') WHERE
   user='root'; 
   mysql> FLUSH PRIVILEGES;

   From this point on, if you need to access MySQL as the MySQL root
   user, you will need to use mysql -u root -p and enter your
   new_password. Remember that MySQL user names have nothing to do with
   Unix user names (login names).


-- 
Minneapolis St. Paul Twin Cities MN        | Phone : (952)943-8700
http://www.mn-linux.org Minnesota Linux    | Fax   : (952)943-8500
Key fingerprint =  6C E9 51 4F D5 3E 4C 66 62 A9 10 E5 35 85 39 D9