MySQL: Change Old Password

$ mysql -uUSER -hHOST -pPASS
mysql> SET PASSWORD FOR username@localhost=PASSWORD('new_password');

- or -

$ mysqladmin -u username password new_password

Ref: http://www-css.fnal.gov/dsg/external/freeware/mysqlAdmin.html