How to change mysql password

Standard
How to change MySQL password


1. Login to mysql
    mysql -u root -p

2. Select Database mysql.
    use mysql;

3. Use this systax to change MySQL password.

SET PASSWORD FOR 'user-name-here'@'hostname-name-here' = PASSWORD('new-password-here');
UPDATE mysql.user SET Password=PASSWORD('new-password-here') WHERE User='user-name-here' AND Host='host-name-here';
Ref : http://www.cyberciti.biz/faq/mysql-change-user-password/