How to Modify WP User through phpMyAdmin

How to Modify WP User through phpMyAdmin

 Note: This guide is showing how to change the user password, but you can also modify more of the user. Such Login, display name,  email. 

You will need to log into phpMyAdmin, if you are not sure how to, you can get all the info right from the panel. 

How to Log in to phpMyAdmin

Then you will see the database in the upper left side

MySQL-databases

Select the database for your site

MySQL-databases-yours

Now you will see the info for that database. What you are looking for contains “users“, the prefix can change, select the options.

wp-users

Then click the browse

Browse

Now you will see your user(s).

wp-user

  You will click the Pencil   (this is the edit button) next to next to the entry to modify it. The edit page:

wp-password-change

For changing your password make sure to change the “Function” to “MD5” (see above)

Then click the GO to save it.

That’s it.