Change a MySQL user password
Contributed by qmchenry 
October 12, 2003 
Tagged: MySQL
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.