Set password for mysql user

How do I set or update password for user of a database ?

….

Login to mysql console

Set:

SET PASSWORD FOR 'username'@'localhost' = PASSWORD('password');

Update:

UPDATE mysql.user SET Password=PASSWORD('password') WHERE User='username' AND Host='localhost';