Loading...

Knowledge Base
Home 
 
/
 How to Reset WordPress Password in phpMyAdmin
Categories: Crazy DomainsDatabasesDatabasescPanelPlesk

How to Reset WordPress Password in phpMyAdmin

Problem 

Although resetting a WordPress password is typically a straightforward process, there are instances when standard methods fail, resulting in being locked out of the website.  

 

Solution 

Fortunately, you can use the phpMyAdmin tool in your hosting account's control panel to directly reset the password from the WordPress database. Select the specific instructions below depending on the hosting platform that you have: 

  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 a 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 user, 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 a 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 user, 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. In your Dashboard, locate your WordPress Hosting product.
  3. Click Manage on the right side.
  4. In the Overview tab, go to the WordPress Sites section.
  5. Find the WordPress site for which you want to change the password, then click MANAGE.
  6. 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.

  7. Once the Live Site or Staging tab is open, scroll down to the Database section and click PHPMYADMIN.
  8. In phpMyAdmin, select the database associated with your WordPress site from the left panel. You’ll see a list of your WordPress database tables.
  9. Locate the wp_users table and click Browse.

    NOTE

    • Your database might have a different prefix, so, you might see <differentprefix>_users instead.
    • If you have more than one WordPress user, 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.
  10. 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. 

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

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

 

 

 

Loading...