How to reset the wordpress admin password through MySQL in linux reseller hosting?

Here we can see about how to reset the wordpress admin password through MySQL.

Kindly foolow the below stpes to change the wordpress admin password.

1.Login to your cpanel of the domain

2.Under the database option, you are able to see the phpmyadmin

3.Click that option, now you are in phpmydmin

4.Click your wordpress admin database

5.Clik the wp-users

6.Go to MySQL section in your PHPMyAdmin.

7.Enter the below query,

UPDATE wp_users SET user_pass= MD5(‘yourpassword’) WHERE user_login=’yourusername’;

Note : Put your new password in place of yourpassword and replace yourusername with your WordPress username.

8.Click to execure the query