1-login to the cPanel and click on the phpMyAdmin icon under the database section.
2- Select the database on the left-hand side. You can find database name in wp-config.php file.
3- select table _users, usually wp_users.
4- Select user and click on Edit icon.
5- Take a look at field user_pass. There is a MD5 encrypted password. You need to generate your new MD5 password.
- Type your new password into user_pass field.
- Click on Go when you are done.
