SET PASSWORD statement allows changing the password for a user in the MySQL server. Provided password is interpreted as a clear text string. The password is passed to the authentication plugin associated with the user. The 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 can also be changed using the
ALTER USER statement. The password is specified by
IDENTIFIED BY clause.
ALTER USER myuser@localhost IDENTIFIED BY 'new_pwd123';