Reset your self-hosted WordPress site admin password
Earlier this year I had installed WordPress on my laptop to do some testing. I ended up abandoning the project due to work load at school. I recently tried to access the WordPress install again only to realize that I couldn’t remember the password. I could not use the built in password recovery because it was not a live site and I had set a fake email address for the admin account. After all it was a test setup.
I did some digging around a found an easy way to get the password reset to something else.
Step 1: Access WordPress Users Table
- Access phpMyAdmin console by browsing to “servername or ip address”/phpmyadmin
- Once loaded the list of databases on you server is listed. Press the ‘+‘ next to the database for your wordpress installation to view tables.
- Locate and select the “wp_users” table
- You will now be presented with the below screen in the right panel
Step 2: Generate md5 Hash
You will now need to replace the lost password with another by generating an md5 hash for that password and then inserting it in the wp_users table
Visit http://www.miraclesalad.com/webtools/md5.php and enter the new desired password in the box provided. The hash code will be generated as you type the new password.
Step 3: Edit User table
- Copy the md5 hash code generated by the website
- Return to the wp_users table view and replace the current hash for user_pass by double clicking on the current hash to enter edit mode, delete the contents and pasting the new hash.
- Follow the same process and paste the hash under user_activation_key column.
Step 4: Login
Now you will be able to login with your new password.
Posted on September 19, 2014, in How-Tos, Tech and tagged md5, md5 hash, password recovery, password reset, reset wordpress admin password, WordPress, Wordpress4. Bookmark the permalink. Leave a comment.