SET PASSWORD

[new v9.0],

[v.10.1.1] - “IDENTIFIED BY” clause is optional for admin users.

set_password_statement
    :    SET PASSWORD OF [USER] username [IDENTIFIED BY old_password] TO new_password 

This command allows you to change the password of an existing user.

Example:

SET PASSWORD OF USER user1 IDENTIFIED BY 'password' TO 'new_password';

Admin user may change password for any user:

SET PASSWORD OF USER user1 TO 'new_password';