How to reset WordPress administrator password by phpMyAdmin
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:
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.
Step 3: Access phpMyAdmin in the hosting Cpanel
Step 4: Find your database name on the left to find the “wp-users” table
Step 5: Left click on the “wp-user” table then click to “Edit” in the right window.
Step 6: In the line user_pass, replace the old string by the md5 string you’ve created above. Finish by clicking “Go” button.
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!