How to reset WordPress Password using phpMyAdmin?

There are two conditions to changing the WordPress Admin password. First, if you have forgotten your password, and second, you want to change your current password according to your convenience.

There are two methods to reset WordPress password. We are going to elaborate on these two methods as your relevance.

If you want a specific password, you should choose the second method, and if you’re going to reset your password, you can choose the first method.

Reset Password Using WordPress Forget Password Link

In this method, we can reset the WordPress password using the link, so you need to follow the steps.

STEP – 1. Open link for reset password

Open your web browser and go to the WordPress login page, e.g., example.com/wp-login.php/, then you should click the link below shown after login boxes “Lost your password?”.

reset wordpress password

STEP – 2. Enter Username Or Email

When you click “Lost your password?” there will be a new page requiring your email or username.

Enter Username or Email

After using your email address or username, you will get an email from WordPress, don’t forget to check your spam box sometimes; these emails are filtered as spams.

When you get the email about resetting the WordPress password link, you need to click on the link and change your WordPress admin password.

If your site not configured with SMPT

When your website is not configured with an SMTP mail server, then you will get an error while resetting the WordPress password using the link.

And the error message you get is shown in the image below. So, we have another method to change the WordPress admin password, which is the database method.

reset wordpress password

Using shared hosting like Namecheap or Hostinger, this method will be more natural for you than Cloud Hosting users.

Reset WordPress Password Using Database

Resetting WordPress admin passwords using the database is very easy. You need to log in to your web hosting control panel or cPanel, and then edit your WordPress admin password from the MySQL database table.

STEP – 1. Open phpMyAdmin

Log in to cPanel and find ‘phpMyAdmin.’

phpMyAdmin on cPanel

STEP – 2. Login to phpMyAdmin

Login to your phpMyAdmin with your credentials to edit or reset your WordPress admin password.

Login phpMyAdmin

Note:When you click on “phpMyAdmin” on the cPanel web hosting dashboard, then possibly “phpMyAdmin” doesn’t ask for any credentials data, like the image shown above.

STEP – 3. Select WordPress Database

When you successfully logged in on phpMyAdmin, you can see some databases table on the left side. Click the first one after “New.” It could be “WordPress,” “bitnami_wordpress,” or “wp_xyz.”

Select WordPress Database

STEP – 4. Find ‘wp_users’ and edit

After clicking the first one or expanding the first one, then there will be showing many other databases field. You should find “wp_users.

Edit wp_users table on Database

Now, You can see above the image “wp_users,” click on “Browse” because all WordPress root credentials and information are stored there.

STEP – 5. Edit WordPress Password

Enter your New WordPress Password

When you click on “wp_users,” then this page (shown above the image) will open to edit your WordPress Password.

You can see the “user_pass” column. First, change the function of “varchar(255)” to MD5 from the default function.

Next, edit the “Null Value” as you want. Above in the picture, you can see I have changed the default or my forgotten password to [email protected].

After editing the WordPress Password, Click on the “Go” button for saving changes. Okay, now the WordPress admin password has been changed.

Wrapping Up

Friends, these are two easy methods I told you above. You can change your WordPress admin password in this way.

If you are having any problem changing the admin password of WordPress, then you can contact us.

Read More:


Please Support

If you like our content, please consider buying us a coffee.
Thank you for your support!

Leave a Comment