Reset a WordPress Password from phpMyAdmin

Note: use phpMyAdmin at your own risk.

• Click your WordPress database.
• All the tables in your database will appear. If not, click Structure.
• Look for wp_users.
• Click on the icon for browse or structure.

The next screen lists the fields within the wp_users table.

• On user_login click browse and find the ID number associated with your login. Remember it.

• Go back to the wp_users table.

• On the user_pass field, click browse and find the ID number associated with your login.

• Click edit.
• Next to the ID number is a long list of numbers and letters.

• Select and delete these and type in your new password.
• Type in the password you want to use. Just type it in normally, but remember, it is case-sensitive.
• In this example, the new password will be 'tweaksit'
• Once you have done that, click the dropdown menu indicated, and select MD5 from the menu.
• Check that your password is actually correct, and that MD5 is in the box.
• Click the 'Go' button to the bottom right.
• Test the new password on the login screen. If it doesn't work, check that you've followed these instructions exactly.

-----updated from Nashim's Nokia for tweaksit.blogspot.com