How can you change the password of a MySQL user?

SET PASSWORD statement is used to change the password of a MySQL user.

Syntax

SET PASSWORD FOR ‘username'@'hostname' = PASSWORD(‘password');