from within mysql:
set password for 'user'@'localhost' = password('cleartext password');

from command line:
mysqladmin -u root -p'oldpassword' password newpass