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.

Recent Articles

How to Hide Shipping Methods in WooCommerce?

This is a small detail, but WooCommerce doesn't have built-in any function for hiding shipping methods based on different situations. Imagine when...

How to Get WordPress Post Featured Image URL

Are you a WordPress developer or an advanced WordPress user? Whoever you are, sometimes you may need the direct URL of a...

How to Bulk Delete Media in WordPress

WordPress and media. That's the topic for a book. Sometimes is not easy to find what you need and when you have...

Custom Order Number for WooCommerce Will Saves You a Lot of Hassle!

WordPress is still the king of Content Management Systems (CMS). Thanks to its open-source nature, millions upon millions of users and PHP...

How to Manually Sort WooCommerce Products

WooCommerce is an e-commerce plugin for WordPress. It is a great way for the user to create an online store for their...

Get in touch

Be our first-class reader, build a community and follow us on social media!

Leave A Reply

Please enter your comment!
Please enter your name here