Wordpress Reset admin password

[Henry H]

http://codex.wordpress.org/Resetting_Your_Password#Through_phpMyAdmin

Through phpMyAdmin

This article is for those who have phpMyAdmin access to their database. Note: use phpMyAdmin at your own risk. If you doubt your ability to use it, seek further advice. WordPress is not responsible for loss of data.

Begin by logging into phpMyAdmin and click databases.

Image #2

• A list of databases will appear. Click your WordPress database.

Image #3

• All the tables in your database will appear. If not, click Structure.
• Look for wp_users.
• Click on the icon for browse.
• Locate your Username under user_login
• Click edit

Image #4

• Your user_id will be shown, click on Edit
• Next to the user_pass 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 'rabbitseatcarrots'
• Once you have done that, click the dropdown menu indicated, and select MD5 from the menu.

Image #5

• 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.

 

Through MySQL Command Line

1. Get an MD5 hash of your password.
   • Visit md5 Hash Generator, or...
   • Create a key with Python. or...
   • On Unix/Linux:
     1. Create file wp.txt with the new password in it (and *nothing* else)
     2. md5sum wp.txt
     3. rm wp.txt
2. "mysql -u root -p" (log in to MySQL)
3. enter your mysql password
4. "use (name-of-database)" (select WordPress database)
5. "show tables;" (you're looking for a table name with "users" at the end)
6. "SELECT ID, user_login, user_pass FROM (name-of-table-you-found)" (this gives you an idea of what's going on inside)
7. "UPDATE (name-of-table-you-found) SET user_pass="(MD5-string-you-made)" WHERE ID = (id#-of-account-you-are-reseting-password-for)" (actually changes the password)
8. "SELECT ID, user_login, user_pass FROM (name-of-table-you-found)" (confirm that it was changed)
9. (type Control-D, to exit mysql client)

Note if you have a recent version of MySQL (version 5.x?) you can have MySQL compute the MD5 hash for you.

1. Skip step 1. above.
2. Do the following for step 7. instead.
   • "UPDATE (name-of-table-you-found) SET user_pass = MD5('"(new-password)"') WHERE ID = (id#-of-account-you-are-reseting-password-for)" (actually changes the password)

Note that even if the passwords are salted, meaning they look like $P$BLDJMdyBwegaCLE0GeDiGtC/mqXLzB0, you can still replace the password with an MD5 hash, and Wordpress will let you log in.