Changing the WordPress password with the help of phpMyAdmin is sometimes which is very useful in some cases, In WordPress you have the option to retrieve the password from using the email address which you filled while creating the blog. The trouble really starts when you have your WordPress website hacked and when you try to retrieve your password using your email then you realize that you are not able to login to your email.
Even then you have an option to change the password to get back the access to your website, you can change WordPress password with phpMyAdmin. Every WordPress website stores all the information on MySQL database, You can make changes to the database table of your WordPress website using phpMyAdmin.
First You have to find the database associated with your WordPress blog.
Find the name of database
With the various features available on hosting plans available now a days you have the option to have multiple websites on same hosting, every WordPress website have their own database. To change WordPress password with phpMyAdmin you have to find the database associated with the WordPress blog for which you like to change the password.
To get the name of database you have to go to wp-config.php in the root of the WordPress directory, there you will find the name of the database associated with the WordPress blog you like to change the password for. The name of the database will be like ***_wrdp31.
After finding the name of the database you should remember it as we are going to make changes to that only.
Changing WordPress password with phpMyAdmin
Now you have to go to the cPanel of your hosting and find phpMyAdmin under database. Click the phpMyAdmin icon.
Now after going in the phpMyAdmin you will see the list of database on the left hand side of the phpMyAdmin window (The list of database is due to multiple WordPress blogs). Now select the database of the website for which you want to change the password.
When you click the database you will be redirected to the list of tables, there you have to find the table named wp_users select it and go to the browse tab, hit edit or pencil icon.
Now you will see fields with user_login,user_pass,etc. What we need is user_pass, in the field on the same line you will see a combination of some random letters and digits. This is your password, you must be wondering that why it looks so different, it’s because of security reasons.
The password is in MD5 format, WordPress stores the password in MD5 hash rather than in plain text format to keep your password secure. In order to replace your password you need a MD5 hash converter
Use the tool: MD5 hash converter
You have to fill the new password in the box of the converter and convert it in MD5 format. You will get a random combination of letters & digits like the one you have in your user_pass. replace the older string with the new one and click go to save the settings.
You have successfully changed the password of your website, you can now login to your WordPress website with the new password.