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.
Then you will see the database in the upper left side
Select the database for your site
Now you will see the info for that database. What you are looking for contains “users“, the prefix can change, select the options.
Then click the browse
Now you will see your user(s).
You will click the Pencil (this is the edit button) next to next to the entry to modify it. The edit page:
For changing your password make sure to change the “Function” to “MD5” (see above)
Then click the GO to save it.