Change a MySQL user password

 For the user molly to change her password to TrckTrt, she would run this command from the shell:

mysqladmin -u molly -p password TrckTrt

The mysqladmin program will prompt for the old password.

courtesy http://www.tech-recipes.com/rx/193/change-a-mysql-user-password/