How to reset your WordPress Admin password via phpMyAdmin

Posted on 08/11/2012 by Neil Skoglund

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.

And that's it! Remember if you need any help with your WordPress hosting, send us a support email and we can help you through it

Comments

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

© Copyright 2019 FreshSites Limited. Registered in England and Wales no. 7812509
Website Design by Pyxal
How to Reset Your Wordpress Admin Password via phpMyAdmin | FreshSites How to Reset Your Wordpress Admin Password via phpMyAdmin | FreshSites How to Reset Your Wordpress Admin Password via phpMyAdmin | FreshSites How to Reset Your Wordpress Admin Password via phpMyAdmin | FreshSites How to Reset Your Wordpress Admin Password via phpMyAdmin | FreshSites How to Reset Your Wordpress Admin Password via phpMyAdmin | FreshSites How to Reset Your Wordpress Admin Password via phpMyAdmin | FreshSites How to Reset Your Wordpress Admin Password via phpMyAdmin | FreshSites How to Reset Your Wordpress Admin Password via phpMyAdmin | FreshSites How to Reset Your Wordpress Admin Password via phpMyAdmin | FreshSites How to Reset Your Wordpress Admin Password via phpMyAdmin | FreshSites How to Reset Your Wordpress Admin Password via phpMyAdmin | FreshSites How to Reset Your Wordpress Admin Password via phpMyAdmin | FreshSites How to Reset Your Wordpress Admin Password via phpMyAdmin | FreshSites