Would you like to reset a lost WordPress password using phpMyAdmin?

If you are unable to reset your WordPress password, there is a way to reset it directly using phpMyAdmin.

In this tutorial, we will show you how to easily reset a WordPress password from phpMyAdmin.

But, if you've never installed WordPress discover How to Install a WordPress Blog et How to search, install and activate a WordPress theme on your blog 

But back to why we are here.

How to reset a wordpress password

Why reset Password from phpMyAdmin

WordPress makes it easy to reset your password. You can simply go to the login screen and click on the "Forgot password?».

Wordpress login page

Clicking on it will take you to the password reset page where you can enter your username or email address to reset the password. After that, WordPress sends a password reset link to the email address associated with that user account.

However, if you don't have access to the email address or if your WordPress website can't send an email, you won't be able to reset your password.

Discover another way to recover your passwords by consulting our article: Simplify your life with a WordPress password manager.

In such a situation, you must reset your WordPress password directly in the database. The easiest way to do this is to use phpMyAdmin.

That said, let's see how you can easily reset a WordPress password from phpMyAdmin.

How to reset a password from PHPMyAdmin

First, you need to login to the cPanel dashboard of your account.accommodation WordPress. Next, you need to click on the “ phpMyAdmin Under the section of the database.

This will launch the phpMyAdmin app where you need to select your WordPress database.

Selecting a wordpress database - reset a wordpress password

You will now see the list of tables in your WordPress database. Then you need to search for the table " {table-prefix} _users In this list and click on the link " Browse " next to it. {table-prefix} will replace the prefix of your database.

Show users

Please note:: Table names in your WordPress database may have a different table prefix than the one we show in our screenshot.

See also our article on How to rename images on a WordPress blog

You will now see the rows for WordPress users. Go ahead and click the edit button next to the username whose password you want to change.

Modify a phpmyadmin user

PhpMyAdmin will present you with a form with all the fields, and user data.

You must delete the value in the " user_pass and replace it with your new password. under the column Function, select MD5 from the drop-down menu and click on the button Execute ».

Using a phpmyadmin md5 function

Your password will be encrypted using the MD5 hash, then it will be stored in the database.

Congratulations ! You have successfully changed your WordPress password using phpMyAdmin.

And if you take a look at How to force users to change passwords on WordPress

Now some of you may be wondering why did we select the MD5 hash to encrypt the password?

In older versions, WordPress used the MD5 hash to encrypt passwords. Since WordPress 2.5, he started using stronger encryption technologies. However, WordPress still recognizes MD5 to provide backward compatibility.

Read also How to complexify the hash of WordPress passwords with bcrypt

As soon as you log in using a password string stored as an MD5 hash, WordPress recognizes it and modifies it using the latest encryption algorithms.

In what follows, I suggest some WordPress plugins to add password protection.

1. WooCommerce Password Protection Products, Categories or Shop

Ce WordPress Plugin allows you to password protect your entire website, a section of your online store, specific categories, products or pages. You will be able to create a password, hide the desired content from the public and share it to specific people.

Woocommerce password protected products categories or shop plugin

You can also choose to display password protected pages in search engine results by allowing them to crawl those pages.

Read How to bypass blockers of ads on WordPress

Its functionalities are among others: password protection for a section or your entire website, the ability to create multiple passwords by importing them to create different rules for accessing your website, customizing the password protection page background, and much more.

Download Demo | Web hosting

2. Google Authenticator 5-Step Login Protection

Ce WordPress Plugin allows you to create a temporary, one-time password generated by your phone. Thus, even if someone knows your password, or has memorized it or even stolen it, they will not be able to connect to your account.

5sec google authenticator 2 step login protection

Its main features are: a two-step login process that adds extra protection to your website, no SMS charges to shell out, no ability to hack your account without your phone, ability to enable or disable two-way authentication Steps an easy-to-use graphical interface, professional and fast customer support, detailed documentation and more.

Download Demo | Web hosting

3. Super Forms 

This is an add-on to the plugin Super Forms, through which you can password protect your forms on your WordPress site. You will also be able to hide the form for non logged in users, as well as specific user roles.

Super forms password protect user lockout hide add on

It is an easy to use module that is compatible with most popular browsers. It is also fully responsive!

Download | Demo | Web hosting

Recommended Resources

Find out about other recommended resources to help you build and manage your website.

Conclusion

So ! That's it for this tutorial. We hope you can better protect your blog. If you have some Comments or suggestions, do not hesitate to let us know in the reserved section.

However, you will also be able to consult our resources, if you need more elements to carry out your projects of creation of Internet sites, by consulting our guide on the WordPress blog creation or the one on Divi: the best WordPress theme of all time.

But meanwhile, share this article on your different social networks

...