• Get In Touch
October 4, 2017

How to Reset a WordPress Password from phpMyAdmin

Using Wordpress? Get our lightening fast Wordpress Optimised Hosting.
Get Wordpress Hosting

If you find that you are unable to reset your WordPress password using the ‘Lost my Password’ option on the login screen, then there is another way to reset it from within your WordPress database using phpMyAdmin.

First off, you will need to head to the phpMyAdmin icon that is displayed under the database section on your Cpanel dashboard. Access the Cpanel by logging into your WordPress Hosting account.

This will now launch the phpMyAdmin app. Down the left-hand side, select your WordPress database.

Clicking this will display a list of all the tables in your WordPress database. You want to select the table that is named ‘(table prefix)_users’. Once you have found this, click ‘browse’ next to it.

You will now be shown the rows within the WordPress users table. You should be able to see the usernames of all the users who possess a login for your WordPress account. By clicking the ‘edit’ button next to a users username, you will be able to edit the password for that account.

Upon clicking edit, you will need to delete the value in the ‘user_pass’ field and replace it with your new password. Under the function column, select ‘MD5’ from the drop-down menu and click the ‘Go’ button.

By selecting ‘MD5’ your password will be encrypted using the MD5 hash and stored in the database.  It’s as easy as that!

Using Wordpress? Get our lightening fast Wordpress Optimised Hosting.
Get Wordpress Hosting

Share this Article!

Related Posts

5 Website Hosting Solution Trends for 2022 and Beyond

5 Website Hosting Solution Trends for 2022 and Beyond

Looking for the right web hosting solution for your website can be an intimidating task. Options nowadays are more diversified than ever, and each year brings new developments in the web hosting market. If you have no clue of what to look out for, you can find yourself overwhelmed with the choices. Hence, you must […]

64 Content Marketing Statistics Demonstrating the Power of Content

64 Content Marketing Statistics Demonstrating the Power of Content

Content marketing continues to be one of the most valuable tools for today’s online businesses. With content, you can improve your chances of reaching your target audience, boost your search engine standing, and even unlock new opportunities for sales. The more content you produce, the more you can strengthen your domain authority, demonstrate your thought […]

53 User Experience Stats for 2022

53 User Experience Stats for 2022

User Experience (UX) is one of the most crucial factors to consider in web design. As the number of websites and applications in the world today continues to accelerate, businesses are under more pressure than ever to impress customers straight away. If a user visits your website and finds slow-loading pages, clunky navigation, or errors, […]

How to increase the memory limit in WordPress

How to increase the memory limit in WordPress

Do you need to increase the memory limit in WordPress? Getting an error about memory Exhausted? The memory limit is one of the most common WordPress errors as the default limit of memory in WordPress is only set to 64mb! But there’s good news! The Memory Exhausted error is one of the easiest to fix […]

All in One WordPress Migration Vulnerability

All in One WordPress Migration Vulnerability

A vulnerability has been discovered in the “All In One WordPress Migration” WordPress plugin. All versions earlier than, and including 6.97 contain a vulnerability which allows Cross-Site Scripting (XSS). With over 2 million active installations, this vulnerability has the potential to be high impact, however, this is lessened by the nature of the vulnerability, which […]