Change User Password in MySQL

The 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';