How to reset WordPress Password
There are many ways to reset a WordPress password, it can be done even if you can’t reset your WordPress Password from the WordPress Admin Program or from your website login page.
TABLE OF CONTENS: 1. Change a WordPress Password in your WordPress Admin. 2. Change a WordPress Password through the “Lost your password?” link on the main login page for your blog or website. 3. Change a WordPress Password through MySQL Command Line - Works perfectly! 4. Change a WordPress Password through phpMyAdmin
1. Change WordPress Password in your WordPress Admin
To change your password in current version 15-Juli-2019:
- In the Administration Screen, menu, go to Users > All Users.
- Click on your username in the list to edit it.
- In the Edit User screen, scroll down to the New Password section and click the Generate Password button.
- If you want to change the automatically generated password, you can overwrite it by typing a new password in the box provided.
- Click the Update User button.
Your new password becomes active immediately.
2. Reset WordPress Password through e-mail
Through the automatic emailerIf you know your username or the email account in your profile, you can use the “lost password” feature of WordPress.
- Go to your WordPress Login page (something like http://yoursite.com/wordpress/wp-login.php)
- Click on the “Lost your password?” link
- You will be taken to a page to enter some details. Enter your username or the email address on file for that account.
- Wait happily as your new password is emailed to you.
- Once you get your new password, login to your profile page and change this password to something you can remember.
3: Change WordPress Password through MySQL Command Line #
- Get an MD5 hash of your password.
- Visit md5 Hash Generator, or…
- Create a key with Python, or…
- On Unix/Linux:
- Create a file called wp.txt, containing nothing but the new password.
- tr -d ‘\r\n’ < wp.txt | md5sum | tr -d ‘ -‘
- rm wp.txt
- On Mac OS X:
- Create a file called wp.txt, containing nothing but the new password. Then enter either of the lines below
- md5 -q ./wp.txt; rm ./wp.txt (If you want the MD5 hash printed out.)
- md5 -q ./wp.txt | pbcopy; rm ./wp.txt (If you want the MD5 hash copied to the clipboard.)
- “mysql -u root -p” (log in to MySQL)
- enter your mysql password
- “use (name-of-database)” (select WordPress database)
- “show tables;” (you’re looking for a table name with “users” at the end)
- “SELECT ID, user_login, user_pass FROM (name-of-table-you-found);” (this gives you an idea of what’s going on inside)
- “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)
- “SELECT ID, user_login, user_pass FROM (name-of-table-you-found);” (confirm that it was changed)
- (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.
- Skip step# 1 above.
- 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.
4. Change a WordPress Password through phpMyAdmin