How one can Reset a WordPress Password from phpMyAdmin

  • January 13, 2023
  • elkenz
  • 4 min read

Do you wish to reset your WordPress password utilizing phpMyAdmin?

In case you are unable to reset your WordPress password, then there’s a solution to reset it straight in your WordPress database utilizing phpMyAdmin.

On this article, we’ll present you how one can simply reset a WordPress password from phpMyAdmin.

How to Reset a WordPress Password from phpMyAdmin

Why Reset WordPress Password from phpMyAdmin?

WordPress makes it tremendous straightforward to get better a misplaced password. You possibly can merely go to the login display of your WordPress web site and click on on the ‘Misplaced your password?’ hyperlink.

Click on 'Lost Your Password?'

While you click on on the hyperlink you’re taken to the password reset web page. When you enter your username or electronic mail handle, WordPress will ship a password reset hyperlink to the related electronic mail handle.

Nonetheless, when you don’t have entry to that electronic mail handle, or your WordPress website fails to ship an electronic mail, you then won’t be able to reset your password.

In such a scenario, you will have to reset your WordPress password straight within the database. The simplest method to try this is through the use of phpMyAdmin.

Having stated that, let’s see how one can simply reset a WordPress password from phpMyAdmin.

How one can WordPress Password From PhpMyAdmin

Subscribe to WPBeginner

Should you don’t wish to watch the video tutorial, then you’ll be able to proceed studying the textual content model beneath.

First, you might want to login to the cPanel dashboard of your WordPress internet hosting account. Subsequent, you might want to navigate to the Databases part the place you’ll be able to click on on the phpMyAdmin icon.

Click the phpMyAdmin Icon

This may launch the phpMyAdmin app the place you might want to choose your WordPress database.

Select Your WordPress Database

You’ll now see the checklist of tables in your WordPress database. It’s essential to search for the wp_users desk on this checklist and click on on the Browse hyperlink subsequent to it.

Click the wp_users Browse Link

Be aware: Desk names in your WordPress database might have a distinct prefix than the one we’re exhibiting in our screenshot. Altering desk prefixes can enhance the safety of your WordPress website.

You’ll now see the rows in your WordPress customers desk. Go forward and click on on the edit button subsequent to the username whose password you want to change.

Click the Edit Button Next to the Username

PhpMyAdmin will present you a kind with all of the person data fields.

You will have to delete the worth within the user_pass area and exchange it along with your new password. Below the operate column, choose MD5 from the drop down menu after which click on on the Go button on the backside of the shape.

Select MD5 and Type Your New Password

Your password shall be encrypted utilizing the MD5 hash after which will probably be saved within the database.

Congratulations! You have got efficiently modified your WordPress password utilizing phpMyAdmin.

A few of it’s possible you’ll be questioning why we chosen the MD5 hash to encrypt the password. WordPress beforehand used MD5 hash to encrypt passwords, however since WordPress 2.5 it has been utilizing stronger encryption applied sciences.

Nonetheless, WordPress nonetheless acknowledges MD5 to offer backward compatibility. As quickly as you log in utilizing a password string saved as an MD5 hash, WordPress will mechanically change it to make use of the newer encryption algorithms.

We hope this tutorial helped you learn to reset a WordPress password from phpMyAdmin.

You might also wish to see our final step-by-step WordPress safety information to maintain your WordPress website secure or try our checklist of will need to have plugins.

Should you appreciated this information, then please contemplate subscribing to our YouTube Channel for WordPress video tutorials. You can too discover us on Twitter and Fb.