How Do I Change My WordPress Password in MySQL?

Changing your WordPress password in MySQL is a simple process. First, make sure you have the correct credentials for the MySQL server. Next, open a command prompt and type the following command:

mysql -u root -p

This will prompt you for your MySQL user credentials. Next, you will need to change your WordPress password. To do this, enter the following command:

mysql -u root -p “UPDATE wp_users SET user_pass=’newpassword’ WHERE user_id=’1′”

Finally, type the following command to confirm the password change:

mysql -u root -p “SELECT user_id FROM wp_users”

Your new password should now be displayed in the results of the SELECT statement.