Change a MySQL user password

Procédure

Connected to MySQL, with the user account, enter:

set password = password("yournewpassword");