How to Reset a WordPress Password from phpMyAdmin
Steps::
Here is a simple method to reset the wordpress password from phpmyadmmin..
Quote:
>> First thing you need to do is to identify your wordpress database name.
>> You can get the database name from your wp-config.php file which is located in your wordpress root directory.
>> Once you locate your database just login to your cpanel >> Databases >> phpmyadmin
>> Then select the exact database on the very left hand side that you located from wp-config.php and click on it.
>> Soon you will be listed with tables with a prefix wp_ for the most part and if ever you have changed the prefix it will display the changed prefix.
>> Then search for the table named as wp_users and click on it. Once done click on the Browse Tab.
>> Then click on the edit icon that look like a pencil in-order to reset your password.
>> There you will find an option called user_pass field value just edit it.
>> In the user password field you will see a lot of random characters in the password field it is because due to some security reasons, WordPress stores the passwords a MD5 Hash instead of Plain text. So even we wont be able to save our password in text in that field. For this we need to use one of the MD5 generators online to generate your password.
You can get it from the link MD5 Generator
>> Just enter you password in front of Input and click on MD5 and it will generate MD5 result which you can copy and paste into your phpMyAdmin field and click Go to save changes.
>> Once it is done you have successfully changed your password and is ready to use.
You have now successfully changed your WordPress Password from phpMyAdmin.
|