Thus in this post, I will take you to the series of steps which are made easy when it comes to reset wordpress password from phpmyadmin. Let’s start with this wordpress tutorial, I would advice you to do the steps as I had mentioned here carefully by opening the tabs in your window and continue doing as per my instructions here. This would facilitate the total learning experience for you. At the last stage of this post, you would be able to learn how to reset wordpress password from phpmyadmin.
You might also like to read on TechGeck:
- 7 Best Laptop Brands 2015 – Reliable & most trusted Models
- 10 Best Digital Cameras 2015 of the World (Most Trusted)
Steps to Reset WordPress Password from phpMyAdmin:
Please follow the steps given below carefully as per the instructions given here to reset wordpress password, you can make better use of it by correlating with the help of pictures given below –
Step #1: Login to your cPanel of your hosting or WordPress installation
In this step just login to your hosting or the cPanel of your wordpress installation, like if your wordpress installation is in hostgator hosting then you would have got some address like – gator4149.hostgator.com:xxxx.
You can also directly access to your wordpress installation by simply typing this in your address bar – Your Website url followed by /cpanel, this will result in redirection of your site to your cpanel homepage as shown in picture given above.
- For example – http://url.com/cpanel
Step #2: Click on the phpMyAdmin and locate the WordPress Database
In this step, you need to locate your WordPress database of your website by clicking on the phpMyAdmin area in the databases section of your cPanel. If you are not aware about your wordpress database, then you can learn from my previous posts on how to know your wordpress database name.
So here we had assumed that our database name is _wrdp18 which is the database of the wordpress installation whose password is need to be changed.
Step #3: Locate and click on the “wp_users” in the sidebar of the database selected in phpMyAdmin
In this step, you need to click on the “wp_users” of your WordPress database selected on the phpMyAdmin to bring about the changes or modifications in the password fields. This step is important to reset WordPress password using phpMyAdmin.
Read more on TechGeck: 10 Best Mobile Phone Companies 2015 of the World
The new password of your wordpress needs to be converted into MD5 format, which codex of the wordpress understands. So for converting your password into MD5, we recommend you to use this tool to convert – MD5 Converter as per the instructions given above in the picture.
Step #5: Select the user_pass field of the wp_users and edit the fields to reset wordpress password
Now come back to the tab here wp_users was open, select and edit the user_pass, here you need to paste by control+V command the new password that you copied after converting into MD5 tool in the Step #4. After pasting the new password, you are done with the complete tutorial to reset WordPress password using phpMyAdmin. Now you go back and login to your WordPress with your username and your new password you changed before MD5 conversion.
Read more on TechGeck: 5 Best Wireless Headphones 2015 under $50 (Most Trusted)
You can pen down your queries or any problems below in the comment section that you faced in complete tutorial to reset WordPress password, I will try to answer to the earliest.