How to Reset WordPress Password from phpMyAdmin easily

We are living in the world of where numerous coding and decoding are taking place each micro second in the form of various programs, passwords and so on. Humans are bound to remember so many passwords to live out their life free from any hacking, intruders and all. To keep yourself safe, we create different combination of passwords – sometimes numeric, alphanumeric, symbols and many more. But it really becomes difficult sometimes to remember so many passwords into the small brain of the humans, as we are not robotic enough to remember the same. Similarly, when it comes to WordPress, we also face situations where we do not remember the password that we set during the creation or installing phase for our clients or for self. Thus, to reset WordPress password becomes a trouble some when we are not knowing how to reset wordpress password from phpmyadmin.

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:

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

How to Reset WordPress Password from phpMyAdmin - Cpanel Step 1

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.

OR

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

How to Reset WordPress Password from phpMyAdmin - Cpanel Step 2

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

How to Reset WordPress Password from phpMyAdmin - Cpanel Step 3

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

Step #4: Create your new password which is MD5 coded which is needed to reset WordPress passwordHow to Reset WordPress Password from phpMyAdmin - Cpanel Step 4

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

How to Reset WordPress Password from phpMyAdmin - Cpanel Step 5

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.

We will be happy to hear your thoughts

Leave a reply

Techgeck - Best Products & Reviews
Techgeck - Best Products & Reviews