If you have lost or forgot your password of your WordPress installation, there is a way to reset it through the WordPress database. The simplest way to edit the database is using the phpMyAdmin tool of your hosting account.
To use the phpMyAdmin tool you will have first to login to cPanel. Then find the Databases category and click the phpMyAdmin icon.
When you see the phpMyAdmin page you will have to select the WordPress database from the drop down menu on the left. The page will load the tables of the database you selected on the right. The go to the SQL tab located at the top bar.
In the SQL tab there is a text box where you have to type the following SQL quiery:
UPDATE `wp_users` SET `user_pass` = MD5('new_password')
WHERE `wp_users`.`user_login` = "username";
Replace the values on the query accordingly:
- new_password - replace it with the new password you want to use.
- username - replace it with the username of the account which you want to change the password with the new_password.
When the SQL query is ready, click the GO button to run the code.
If the process completes with no errors, then the password of the selected username will be changed and you will be able to login again in the WordPress control panel.
