Hostnirvana Support
Control Panel →

Hostnirvana Support Docs

Here you can find all the help documents and tutorials

How to Reset Your WordPress Password in phpMyAdmin

January 27, 2026 — hnsupport

Finding your WordPress password in phpMyAdmin isn’t as simple as reading it directly.
For security reasons, WordPress stores passwords as encrypted hashes, not plain text.

This means you cannot view your current password, but you can reset it to a new one.

Follow the steps below to reset your password safely.


✅ Steps to Reset Your Password in phpMyAdmin

1. Access phpMyAdmin

Log in to your hosting control panel and open phpMyAdmin from the Databases section.


2. Select Your Database

From the left sidebar, click your WordPress database name.

💡 Not sure which one?
Check the DB_NAME value inside your wp-config.php file.


3. Locate the Users Table

Find the table named:

wp_users

⚠️ Your table prefix may be different (example: wp123_users).

Click on the table to open it.


4. Edit Your User

Find your username in the list and click the Edit (✏️ pencil icon) next to it.


5. Change the Password

Inside the edit screen:

  • Locate user_pass
  • In the Function column → select MD5
  • In the Value column → delete the existing hash
  • Type your new password in plain text

6. Save Changes

Scroll down and click Go to save.

Your password is now reset ✅


🔎 Why Use MD5?

WordPress now uses stronger encryption methods, but it still supports MD5 for backward compatibility.

After you log in with the new password:

  • WordPress automatically converts it to a more secure hash format

So you don’t need to worry about security.


🎯 Done!

You can now log in to your WordPress dashboard using your new password.