Reset a user's password of WordPress through phpMyAdmin

To reset a user's password in WordPress, follow these steps:

  • Log in to your cPanel account.
  • Access "phpMyAdmin."
  • Select the correct database name.
  • Locate and click on the "wp_users" database table.
  • Find the user whose password you want to change/reset.
  • Click on the "Edit" option.

  • In the "user_pass" field, select varchar(255) = MD5.
  • Enter the desired password in the field and submit.
  • Finally, go back to the WordPress login page and try logging in with the new password.

That's it!

Tip: If you do not know the database name, go to the File Manager. Switch to the directory where the WordPress files are contained. Open the file: wp-config.php with any Code Editor that is integrated with the File Manager and there you'll get the database credentials along with the database name!

  • 1 Users Found This Useful
Was this answer helpful?

Related Articles

How to Reset the Admin Panel Password in DataLife Engine

To reset the admin panel password for DataLife Engine (DLE) from phpMyAdmin, follow these steps:...

Steps to Allow Remote Database Access with a Wildcard Host

To configure remote database access for cPanel, allowing a host with a wildcard (%), you would...

Fixing Missing or Broken wp_aioseo_cache Table (AIOSEO)

If you are seeing errors related to the wp_aioseo_cache table (e.g. missing columns like key or...

Accessing MySQL Using a Stored Password (CyberPanel)

On servers managed by CyberPanel, the MySQL root password is stored in a local file. Instead of...