Loading...

Knowledge Base

How To Reset WordPress Password via phpMyAdmin

Problem

While resetting a WordPress password is usually a simple process, there are times when standard methods may not work, leaving you locked out of your site.

 

Solution 

Luckily, you can use phpMyAdmin from your hosting account's control panel to reset the password directly in the WordPress database. Follow the instructions below according to your hosting platform:

  1. Log in to your cPanel
  2. Scroll down to Databases and click phpMyAdmin
  3. On the left side of your phpMyAdmin page, click the database that you want to access. You will then see the list of your WordPress database tables. 
  4. Locate the wp_users table, then click Browse.
    NOTE
    • Your database might have a different prefix, so, you might see <differentprefix>_users instead.
    • If you have more than one WordPress users, you need to check each wp_users table to ensure it is the correct user that you want to update. Just check the user_login and user_email columns after opening the wp_users table to verify.
  5. After opening the wp_users table, click Edit.

    IMPORTANT. Make sure you are editing the correct user. Always check the user_login and user_email columns to verify. 

  6. Go to user_pass row. 
  7. Replace the value box with your new password
  8. Select MD5 in the varchar(255) dropdown menu. 
  9. Click Go at the very bottom of the page.
 

That's it. You've successfully changed your WordPress password.

 

  1. Log in to your Plesk
  2. On the left sidebar, click Databases
  3. Locate the database you want to access and click phpMyAdmin. You will then see the list of your WordPress database tables. 
  4. Locate the wp_users table, then click Browse.
    NOTE
    • Your database might have a different prefix, so, you might see <differentprefix>_users instead.
    • If you have more than one WordPress users, you need to check each wp_users table to ensure it is the correct user that you want to update. Just check the user_login and user_email columns after opening the wp_users table to verify.
  5. After opening the wp_users table, click Edit.

    IMPORTANT. Make sure you are editing the correct user. Always check the user_login and user_email columns to verify. 

  6. Go to user_pass row. 
  7. Replace the value box with your new password
  8. Select MD5 in the varchar(255) dropdown menu. 
  9. Click Go at the very bottom of the page.
 

That's it. You've successfully changed your WordPress password.

 

  1. Log in to your Account Manager,
  2. From the products menu on top, select WordPress.
  3. In the Overview tab, go to the WordPress Sites section.
  4. Find the WordPress site for which you want to change the password, then click MANAGE.
  5. Click the Live Site or Staging tab:
    • Live Site: Your website in production, or your official live website.
    • Staging: This is where you make your changes before pushing it to the production or live site.

  6. Once the Live Site or Staging tab is open, scroll down to the Database section and click PHPMYADMIN.
  7. In phpMyAdmin, click the database associated with your WordPress site from the left panel. You’ll see a list of your WordPress database tables.
  8. Locate the wp_users table, then click Browse.
    NOTE
    • Your database might have a different prefix, so, you might see <differentprefix>_users instead.
    • If you have more than one WordPress users, you need to check each wp_users table to ensure it is the correct user that you want to update. Just check the user_login and user_email columns after opening the wp_users table to verify.
  9. After opening the wp_users table, click Edit.

    IMPORTANT. Make sure you are editing the correct user. Always check the user_login and user_email columns to verify. 

  10. In the user_pass row, replace the value box with your new password
  11. Select MD5 in the varchar(255) dropdown menu. 
  12. Click Go at the very bottom of the page.
 

That's it. You've successfully changed your WordPress password.

 

 

 

 

Loading...