How can we change MySQL user password by using the SET PASSWORD statement?

MySQLMySQLi Database

We can use SET PASSWORD statement to change the password. Before using this command, we need to have at least UPDATE privileges. Its syntax would be as follows −


SET PASSWORD FOR ‘user_name@host_name’=new_password;

Here, New_password would be new password we want to set for MySQL user

User_name is the name of the current user.

Host_name is the name of the host of the current user.


Suppose if we want to change the password user@localhost to ‘tutorials’ then it can be done as follows −

SET PASSWORD FOR ‘user@localhost’= tutorials;
Published on 20-Feb-2018 17:26:18