• Get In Touch
November 8, 2012

How to reset your WordPress Admin password via phpMyAdmin

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

If, like many of us, you’ve managed to forget the password for your WordPress Admin panel, don’t worry, you can follow our simple steps to reset it through phpMyadmin.

  1. Log in to your cPanel account:
  2. Scroll down to ‘Databases’ and select ‘phpMyAdmin’:
  3. Select your WordPress database at the left, and then select the wp_users table:
  4. You will now see a list of your users, select the ‘Edit’ option for your admin account:
  5. The field we need to edit is the ‘user_pass’ section, you will notice it’s a string of seemingly random characters, this is your password after it has been md5 encrypted, this keeps your password more secure. In order to change your password, we first need to generate an md5 version of the password you wish to use, I recommend you use This md5 generator to generate the md5 hash:
  6. Copy the string that is generated (without the quotation marks) and paste it into the user_pass box in phpMyAdmin. Now click on ‘Go’ and your password will be updated.
  7. You can now log into your WordPress Admin account with your new password.
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 […]