SET PASSWORD new_password old_password
This statement is used to change the user's password.
SET PASSWORD newpass oldpass SET PASSWORD mynewpass ''42pass''