How do I change my MySQL password?

At the "mysql>" prompt, type:

set password = password("yournewpassword");