Resetting WordPress Admin login password is one of the common aspect to cater for loss of password and hacking. The password of wp admin login can be changed from phpMyAdmin. In case of Cpanel Hosting WordPress blog uses a MySQL Database which can be accessed through phpMyAdmin. Follow the following steps to reset your WordPress password:
Step 1 – Identifying the Name of WordPress Database
To check the password in phpmyadmin, one needs to know the database name. The best place to look is your wp-config.php file which is located in root WordPress Directory. In it you can find the name of your database.
Step 2 – Locating Database and Editing the Fields
In your cPanel or other admin panel, go to phpMyAdmain, access your MySQL database and then browse it. The images below explain how to do it. In capnel phpmyadmin icon would be showing up as under:
Once n phpMyAdmin, select the related database (left side, as per the name you found in wp-config.php). Click the database name and find list of tables with a prefix wp_ for the most part (unless you changed the prefix name during installation) - Find table wp_users, click on it and then click on the Browse Tab as per image below:
You will find the login user name and related password column in the table as per image below. You have to locate the admin user (admin or whatever name you have kept for the admin. Here you can see that the password is showing lot of random characters.
The random characters in the password field of the wordpress are due to security reasons, WordPress stores the passwords as MD5 Hash instead of Plain text. To change the password you have to use MD5 characters for the chosn new password. One of the MD5 generators online to generate your password. is JavaScript MD5
Simply type new password in this tool and generate MD5 equivalent. Copy and paste the code you get from the converter into your phpMyAdmin field and click Go to save changes.
You have now successfully changed your WordPress Password from phpMyAdmin.