This Tutorial will help you in resetting password of your word press users from backend.

Go to SQL Editor and execute the below command to create MD5 encryption password

Copy result of the above command which we need to update in users table of word press

 

Browse to the wordpress installation directory you can see the file name as wp-config.php which hold you wordpress database user,password,Database name

by using this credentials connect to database using any mysql client. you will have a table name ends with users  copy the table name

in my case table name is wo_users as shown in screen shot

execute the below select command to see the all users and to get id of user to reset password.

select the user id as shown below

get the User Id as highlighted above and execute the update command to reset password

 

in my case Query will be

commit the changes and try with new password. you should able to login into word press admin

 

 

Leave a Reply

Your email address will not be published. Required fields are marked *