Library Technology – Reviews, Tips, Giveaways, Freeware

How to reset WordPress administrator password by phpMyAdmin

Posted In Webmaster, Wordpress tips - By Techtiplib on Friday, December 20th, 2013 With 1 Comment

Sometimes you forget the WordPress administrator password because you do not remember or someone changed it, and the WordPress administrator password resetting function via email does not work! So how to reset your password? Below is the guide which helps you recover your administrator password by phpMyAdmin,  just following steps:

Step 1: Remember the name of your database, if you don’t remember, just access and open the “wp-config.php” file to get the info:

database name in configphp

Step 2: Create a new password as an md5 string. 

Accessing this website: md5.net – the site allows you create a new password as an md5 string, then type your new password in the “String” blank then click “Generate” button. Copy the md5 string.

create new password by md5-net

Step 3: Access phpMyAdmin in the hosting Cpanel

Access phpMyAdmin

Step 4: Find your database name on the left to find the “wp-users” table 

find the table wp-users in phpMyAdmin

Step 5: Left click on the “wp-user” table then click to “Edit” in the right window.

edit the table wp-users

Step 6: In the line user_pass, replace the old string by the md5 string you’ve created above. Finish by clicking “Go” button.

edit the table wp-users-change password

Now you can access your WordPress administrator by the new password as you’ve created in step 2.

>> Read more: How to reset WordPress administrator password by FPT?

DONE!

Hope this tip helpful for you!

About - Hey, this blog belongs to me! I am the founder of TechTipLib and managing editor right now. And I love to hear what do you think about this article, leave comment below! Thank you so much...