Skip to main content

How to Reset a WordPress Administrator Password in phpMyAdmin

You can reset a WordPress administrator password using phpMyAdmin if you are locked out of your dashboard or cannot access the WordPress admin area. This procedure allows a Site Administrator to manually update the password for any user account within...

You can reset a WordPress administrator password using phpMyAdmin if you are locked out of your dashboard or cannot access the WordPress admin area. This procedure allows a Site Administrator to manually update the password for any user account within the WordPress database.

Before you begin

You will need:

  • Site Administrator access to the hosting control panel (e.g., cPanel or Windows Control Panel).

  • Access to the phpMyAdmin tool.

  • The exact username of the account you wish to update.

Resetting the password in phpMyAdmin

  1. Log in to your hosting control panel.

  2. Open the phpMyAdmin tool.

  3. Select the database associated with your WordPress site from the list on the left.

  4. Locate and click on the wp_users table. (Note: Your table prefix may differ; for example, it might be wp_7a2_users.)

  5. Find the row corresponding to the administrator user you want to update and click Edit.

  6. Locate the user_pass field.

  7. In the Function dropdown menu for that row, select MD5.

  8. Delete the existing string in the Value field for user_pass and enter a new password (e.g., NewPass123!).

  9. Click Go at the bottom of the page to save the change.

Warning: Ensure you select MD5 from the Function dropdown. WordPress requires passwords to be hashed; entering a plain-text password without selecting MD5 will result in an "Incorrect Password" error when you attempt to log in.

Confirm the result

  • Log in to your WordPress dashboard using the new password.

  • The login is successful if you are redirected to the WordPress dashboard.

If you cannot find the correct database

If you see multiple databases and are unsure which one contains your WordPress data, check the wp-config.php file in your site's root directory. The DB_NAME value in that file identifies the correct database.

Limitations

This procedure updates the password directly in the database. It does not change the email address or other profile details associated with the user account.

Did this answer your question?