Change a MySQL user password
Contributed by qmchenry 
Tagged: MySQL How do I update a user’s password in my MySQL server?
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.
You may also like -
Change the MySQL Root User Password
Connect to a MySQL server using the mysql command
Leopard: How to Install Wordpress
Create a MySQL user account
Display a list of databases on a MySQL server
MySQL - Daily database dumps, all nicely sorted.
Solve: Can't connect to local MySQL server through socket /tmp/mysql.sock
Leopard: Install Local Wordpress using MAMP
no one said on April 17, 2009
WTF… lol