Resetting WordPress password can also be done by the administrator from MYSQL Database, where all the users data is saved.
In my previous post, I wrote how wordpress admin / users can recover their lost passwords using ‘Lost your Password’ option available on the login page.
In this post we shall see how we can reset / recover wordpress password directly from the database using phpMyAdmin.
Resetting the WordPress user passwords is very easy from the wp_users table by using the admin account. Please be reminded that the below mentioned procedure will work only on the WordPress 2.0 and the ones that were released after that.
To change the password, the administer will need to login to phpMyAdmin, and connect to the MySQL database. Once logged in, you should be able to find the wp_users table option which is normally found in the last row.
Here under the action column, you will need to click on the browse icon for wp_users table. You need to locate the user for which you want to reset the password, and you will need to click on the edit icon.
Under the User_pass field, you will need to delete the existing encrypted entry and replace it with a new password. Please be reminded that the password will be case sensitive.
Under the functions column, you will need to select MD5 for the pull down menu and then click on GO. The new user password will be saved now.
How to Reset / Recover Default WordPress Administrator Password
WordPress is a Blog publishing application that is powered by PHP and MySQL, and it is gaining a lot of popularity these days, especially due to the abundance of user friendly features that they provide. Once installed you’ll need a username and password for gaining access to all features like :
o Posting Blogs and entries
Losing a password or username could be really frustrating, especially if the user is a WordPress Blog administrator. The person wouldn’t be able to manage the Blogs without entering the proper username and password. To avoid such circumstances, WordPress has an inbuilt system which enables the user or administrator to recover the lost password.
During this password recovery process, WordPress users will not be able to view the existing password since it gets encrypted. Hence the password will be reset to a new password by using the Password Recovery method. After resetting the password, the user will be able to login to the WordPress Dashboard.
The easiest way to recover the password has always is by using the ‘Lost Your Password’ option. Once you click on the lost your password link, WordPress will provide access to a page where the user will be able to enter username or email address. Then the user has to click the ‘Get Net Password’ button. Instantly an email containing your present password is being sent to e-mail address that you provide.
The password recovery process will work only if the user provides a valid email address, the one which was used while registering the user profile. You will not be able to do the password recovery if you provide any other e-mail addresses. Once you receive the password on the e-mail, it would be better for you to reset it for security purposes.