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