How to set password to an existing MySQL user account?

SET PASSWORD statement assigns a password to an existing MySQL user account.

For example,

> SET PASSWORD FOR 'user_name'@'host_name' = PASSWORD('newpass');

> where user_name and host_name are exactly as they are listed in the User and Host columns of the mysql.user table entry.