How to Reset WordPress Admin Password from cPanel

Quick Summary

If you cannot log in to WordPress admin, you can reset the password from phpMyAdmin in cPanel.

Before You Start

You need:

  • cPanel access
  • Database name used by WordPress
  • phpMyAdmin access

Step 1: Find the Database Name

  1. Log in to cPanel.
  2. Open File Manager.
  3. Open your WordPress folder.
  4. Open wp-config.php.
  5. Find DB_NAME.

This is your WordPress database name.

Step 2: Open phpMyAdmin

  1. Return to cPanel.
  2. Open phpMyAdmin.
  3. Select the WordPress database.

Step 3: Open Users Table

Look for a table ending with:

_users

Examples:

wp_users
wpxy_users

Click the users table.

Step 4: Edit Admin User

  1. Find your admin user.
  2. Click Edit.
  3. Find the user_pass field.
  4. Enter the new password.
  5. Select MD5 from the function dropdown.
  6. Save changes.

Step 5: Log in to WordPress

Go to:

https://yourdomain.com/wp-admin

Use the new password.

Important Security Steps

After login:

  1. Change the password again from WordPress profile.
  2. Use a strong password.
  3. Check admin users.
  4. Remove unknown users.
  5. Update plugins and themes.

Common Problems

Problem: Cannot find wp_users table.
Solution: Your database may use a different table prefix.

Problem: Password still does not work.
Solution: Confirm you edited the correct database.

Problem: User is missing.
Solution: The admin user may have been deleted or database may be incorrect.

Need Help?

Open a support ticket:

https://bill.cybrohost.com/submitticket.php

Was this answer helpful? 0 Users Found This Useful (0 Votes)