Reset WordPress admin user password by editing Users table

I forgot the password of my testing WordPress site on XAMPP  on my local PC. To reset the password , following the below steps:

  1. Access  phpMyAdmin
  2. Open the WordPress database.
  3. Click on the users table in the left menu (ie wp_users)
  4. Click BROWSE.
  5. Click on the EDIT button next to the admin user (i.e. wpsite1-admin).
  6. Delete whatever is in the password field.
  7. Enter your desired password.
  8. From the Function drop-down list, choose MD5.
  9. Save the info in the database.
  10. Log in to WordPress using “wpsite1=admin” and the password ‘admin123’.

Leave a Reply

Your email address will not be published. Required fields are marked *