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 remove category & tag base from WordPress URL

    Would you like to remove the category & tag base from WordPress URL? Do you need custom URL's? It's a super simple!...

    How to Disable Right Click on WordPress

    Are you worried about having your images stolen from your WordPress website? Then you need to know how to disable right click on...

    How to redirect HTTP to HTTPs in .htaccess

    Today's standard is to have an https certificate. Google will love you if your sites are secured. So https is not standard,...

    How to fix TypeError: $ is not a function in WordPress

    We can guess. You purchased a theme or plugin and a console shown a message "TypeError: $ is not a function"? Ok,...

    How to fix Unknown collation: ‘utf8mb4_unicode_520_ci’

    Unknown collation is probably caused because your local and live server are running different versions of MySQL. This problem mostly comes when...

    Related Stories

    Leave A Reply

    Please enter your comment!
    Please enter your name here

    Stay on op - Get the daily news in your inbox