Saturday, 14 February 2015

Tagged under:

How to Reset a WordPress Password from phpMyAdmin.

Just how to reset your wordPress password from phpMyAdmin is one of the essential things you need to know about because for reasons uknown if your site is hacked, or something different, you are no further able to login to your admin panel using the login information,

and you are incapable of reset the password via email, this process can be very useful. We've helped three users with exactly the same issue therefore we have decided to do this writeup.

To Change Your Password

In the Admin Panel menu, go to USERS

  1. Click on your username in the list to edit
  2. In the Edit User screen, scroll down to the New Password section and type in a new password in the two boxes provided. The strength box will show how good (strong) your password is.
  3. Click the UPDATE PROFILE button
  4. Your new password takes effect immediately.

Through phpMyAdmin

phpMyAdmin at your own risk. If you doubt your power to use it, seek further advice. WordPress isn't responsible for loss in data.



logging into phpMyAdmin and click databases.
  1. A list of databases will appear. Click your WordPress database. 
  2. All the tables in your database will appear. If not, click Structure. 
  3. Look for wp_users. 
  4. Go through the icon for browse. 
  5. Locate your Username under user_login 
  6. Click edit (may look like a pen icon in a few versions of phpMyAdmin
  7. Your user_id will undoubtedly be shown, select Edit 
  8. Close to the user_pass is really a long set of numbers and letters. 
  9. Select and delete these and type in your password. 
  10. Enter the password you want to use. Just type it in normally, but remember, it is case-sensitive. 
  11. In this example, the newest password will undoubtedly be'rabbitseatcarrots' 
  12. Once you've done that, click the dropdown menu indicated, and select MD5 from the menu. 
  13. Check that the password is actually correct, and that MD5 is in the box. 
  14. Click the'Go'button to underneath right. 
  15. Test the newest password on the login screen. When it doesn't work, check that you've followed these instructions exactly.

1 comments: