SET PASSWORD statement allows to change the password for user in the MySQL server. Provided password is interpreteted as a cleartext string. Password is passed to the authentication plugin associated with the user. Result returned by the plugin is stored in the
authentication_string column of the
mysql.user system table.
SET PASSWORD FOR myuser@localhost = 'new_pwd123';
A user’s password also can be changed using
ALTER USER statement. The password is specified by
IDENTIFIED BY clause.
ALTER USER myuser@localhost IDENTIFIED BY 'new_pwd123';