Change Admin Password of Your WP site using phpMyAdmin Only

Change Admin Password of Your WP site using phpMyAdmin Only

We got clients sometimes who have lost their WordPress dashboard login information as well as FTP credentials and they have no way to access at the dashboard of their own WP site. However, if they could provide the cpanel login information, then you can easily recover/reset the dashboard login credentials. Here is the process how you can accomplish that:

Login to cpanel
Go to File Manager
Find WP installation root directory and find the wp-config.php file there
If you open that file in a editor, you will get the database username and database password there like below

/** The name of the database for WordPress */
define('DB_NAME', 'sample_db');

/** MySQL database username */
define('DB_USER', 'sample_user');

/** MySQL database password */
define('DB_PASSWORD', 'sample_pass');

Now that, you know the database name for your WordPress site
Goto phpMyAdmin from cpanel
Find the Database for your WordPress site
Goto table wp_users. If you can’t see any wp_users table, then you need to go *_users table. here * is your table prefix
You will find the admin password from there. But, you will get that in a encrypted format
Typical WordPress Database

To change your password, you also have to set your password in encrypted format. You can use this Tool to make your new password in a encrypted format. For example, type new password here as “sample_password” and it will provide you the encrypted format output
Once you have the new encrypted format password, replace the existing one that is present on the ‘user_pass’ field
Now go to your dashboard login page and place the username and new password (not the encrypted format, use normal format for example “sample_password” ) and congrats you got access to the site dashboard!