Reset WordPress Password: WordPress Recovery Email vs phpMyAdmin for Recovering Admin Access

Use the WordPress recovery email first. It is safer, faster, and keeps you away from the database unless email is broken or the admin account has been changed. WordPress powers about 43% of all websites, so password reset problems are common, not weird [source: W3Techs]. If the reset email never arrives, then phpMyAdmin is the solid backup plan for restoring admin access.

TLDR: Start with the built-in WordPress “Lost your password?” email reset because it changes only the password and avoids risky database edits. If email delivery is broken, your admin email is wrong, or the account was hijacked, use phpMyAdmin to update the password directly in the wp_users table. For example, a small agency managing 25 client sites may see 3 or 4 password reset emails land in spam each month, while phpMyAdmin fixes the issue in under five minutes when hosting access is available. Use phpMyAdmin only after confirming you have the right database and a backup.

Recovery Email vs phpMyAdmin: The Quick Decision

The recovery email method is best when your site can send mail and you still control the admin email inbox. It works from the WordPress login screen and needs no hosting panel access. Click Lost your password?, enter your username or email, then follow the reset link.

phpMyAdmin is best when WordPress email is dead, SMTP is misconfigured, the reset link expires, or the admin email address is no longer yours. It works at the database level. That makes it powerful. It also means one wrong edit can lock you out harder than before.

Method 1: Resetting Your WordPress Password by Recovery Email

This is the clean method. WordPress creates a secure reset link and sends it to the email address tied to the account. You set a new password. Done.

Use this method when:

  • You know the admin username or email.
  • You can access the related email inbox.
  • Your site sends email correctly.
  • You do not suspect the admin account was taken over.

Steps:

  1. Go to yourdomain.com/wp-login.php.
  2. Click Lost your password?.
  3. Enter your username or email address.
  4. Check your inbox and spam folder.
  5. Open the reset link and create a strong new password.

Honestly, it feels like this should always work. But WordPress email can be annoyingly fragile. A host may block PHP mail. A security plugin may interfere. DNS records like SPF, DKIM, or DMARC may be missing. The result is simple: no email, no reset link, and 20 wasted minutes refreshing the inbox.

If the email does arrive, this method is ideal. It keeps the database untouched and preserves the normal WordPress password hashing process. WordPress also documents this standard reset flow for users who still have inbox access [source: WordPress.org].

Method 2: Resetting the Password with phpMyAdmin

phpMyAdmin lets you edit the WordPress database through your hosting control panel. You can update the admin password directly in the users table. This bypasses the broken email system entirely.

Use phpMyAdmin when:

  • The reset email never arrives.
  • The admin email is outdated.
  • The reset link says it is invalid or expired.
  • You have hosting access but no WordPress dashboard access.
  • You need emergency access after a plugin or user issue.

The catch is that phpMyAdmin does not protect you from yourself. Click the wrong database, edit the wrong row, or remove the wrong value, and your quick fix becomes a cleanup job.

How to Reset a WordPress Admin Password in phpMyAdmin

Before touching anything, create a database backup from your hosting panel. Even a small SQL backup can save hours of pain.

  1. Log in to your hosting control panel.
  2. Open phpMyAdmin.
  3. Select the database used by your WordPress site.
  4. Open the table named wp_users. Your prefix may be different, such as abc_users.
  5. Find the admin account by checking the user_login or user_email column.
  6. Click Edit on that user row.
  7. Find the user_pass field.
  8. In the function dropdown, choose MD5.
  9. Type your new temporary password in the value field.
  10. Click Go or Save.

Now log in to WordPress with the new password. After you get in, change the password again from Users > Profile. WordPress will replace the temporary hash with its stronger password storage format.

Important: Do not keep using the temporary MD5 password longer than needed. WordPress accepts it for compatibility, then updates it after login. Treat it as a bridge, not as a permanent setup.

Which Method Is Safer?

The recovery email method is safer for most site owners. It works inside WordPress and avoids manual database work. It also reduces the chance of editing the wrong account.

phpMyAdmin is safe only when used carefully. It is not dangerous by itself, but it gives you direct access to sensitive data. That power comes with risk. If your site has multiple databases, staging copies, or custom table prefixes, slow down and verify everything.

Method Best For Main Risk
Recovery email Normal password resets Email may not arrive
phpMyAdmin Broken email or lost admin inbox Wrong database edit

Common Problems and Fast Fixes

Reset email goes to spam: Check spam, promotions, and quarantine folders. Also search for your site name or “password reset.”

Reset link expired: Request a fresh link. Do not reuse an old one from yesterday.

You cannot find wp_users: Your site may use a custom table prefix. Look for a table that ends in _users.

You see several databases: Check wp-config.php in your site files. The database name is listed beside DB_NAME.

You changed the password but login still fails: Clear caching, confirm the username, and make sure you edited the live site database, not a staging copy.

After You Regain Admin Access

Do not stop at “I’m back in.” A password reset may be a routine mistake, but it can also be a warning sign.

  • Change the password again inside WordPress using a long, unique password.
  • Check admin users and remove anything unfamiliar.
  • Update the admin email if it is old or shared.
  • Enable two-factor authentication for all admin accounts.
  • Review recent plugins if the lockout started after an update.
  • Fix email delivery with SMTP so future resets work.
  • Save emergency hosting credentials in a secure password manager.

Best Recommendation

Use the recovery email first because it is simple and low risk. If it fails, use phpMyAdmin with a backup and a clear head. The best setup is having both options ready: working email for normal resets and hosting access for emergencies.

A locked WordPress admin account feels worse than it usually is. In most cases, recovery email fixes it in a minute or two. When it does not, phpMyAdmin gives you a direct route back in. Just respect the database, double-check the user row, and replace the temporary password as soon as the dashboard loads.