Change password for MySQL user

To change the password of any MySQL user, please login to MySQL with the user have right permission to change the data in the database.

Here, I will use the root account:

Enter and then enter the password.

By default, all user information is stored in the mysql database, which is created by default when you install MySQL.

Now, we will announce the mysql database:

And use the UPDATE statement to update the password for the user you want:

Finally, we need to run the following statement for our changes to take effect:

Add Comment