

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