How to Reset a WordPress Password from phpMyAdmin


You decided to use WordPress to set up your personal or professional website. You’ve been working really hard to come up with an impressive layout, a catchy landing page with a creative theme, not to mention all those on-site functions that make your website unique, user-friendly and fast. As you dived into working on your dream website you forgot about your admin WordPress credentials, and now you can’t log into your WordPress dashboard to make the final changes before actually publishing your website. So, as you try to retrieve your credentials using the “Lost your password?” function you realize that the system is not recognizing your email address and you are not receiving the recovery information you need to get access back.

The easiest and most practical solution is using phpMyAdmin, thanks to which you will be able to reset your WordPress password by accessing the database of the platform. With these brief guide, hopefully, you will be able to move on with your project and publish a terrific website as soon as possible.

Here’s what you have to do on pHPMyAdmin.

You will need to log in the dashboard of your WordPress hosting account, then you will click on the phpMyAdmin icon. This will launch the software and you will be presented with a list of tables that correspond to specific sections of your WordPress site. What you will be looking for precisely is a table labeled “users”. Then you will need to click on the “browse” link and you will be presented with a list of WordPress usernames. In the case you are only hosting one account you will only have one username on that list, which is the one you are trying to recover the password for. Now, on the row that contains your user ID, you will have to click on “edit”. On the same row, you will see a column labeled “user_pass”. That’s where you will be able to change your password. The procedure will be completed by selecting the “MD5” option under the “Function” column. This will ensure that the password will be correctly encrypted into the database. Click “Go”, now your new password is all set and you are ready to log in your WordPress dashboard again. This time, make sure you write down your credentials so that you won’t forget them anymore and you won’t be slowed down.

Give yourself some time to work through the phpMyAdmin software, follow this article to the letter and you’ll be good to go. But if you can’t make any sense of it, don’t stress yourself out, you can look for video tutorials for a step-by-step guide on YouTube. Using phpMyAdmin is easier done than said.

Add comment

Recent Posts


Recent Comments