Today’s quick tip will go over changing your WordPress passwords via your website’s database. Have you ever forgotten your password for your WordPress website’s admin account? Maybe you didn’t have access to the email it was under, or the”reset password” link wasn’t working for you. Or maybe a client forgot the password to their admin account, with no way to access the website’s backend. With today’s tip, you’ll be able to easily change the password for any account created for your WordPress website.
Changing your WordPress password via your database
If you have multiple databases on your web hosting account, please make sure you know which is the correct database for the WordPress website. Once you know which database your website uses, you will need to access your databases. You can do this via cPanel under Databases > phpMyAdmin. Once your databases load up, expand the database that your WordPress website uses.
After you expand the database, you will need to look for the table wp_users. The tables are listed in alphabetical order by default, so the table will be near the bottom of your list. Select the table once you find it, and phpMyAdmin will load the table’s contents.
Once the table’s contents are loaded, you will see a list of all the accounts that are created for your website. Look for the account that you would like to change the password for by looking at the user_login column. After you found the account, select the edit link that is under the options column.
On the following page that loads, you will be able to edit the account’s information. Here you see a string of seemingly random numbers, letters and symbols for the password. You will be able to replace that old password with any new password you would like without worrying about encrypting it before hand. Once you have typed in the new password, please make sure to change the Function (the drop down menu to the left) to MD5, and then you can Go at the bottom of the page. This will change the password for the account that you were editing. After you have saved the changes, you can log in with the new information to test that the password change worked.
Now you know how to change the password for any account for your WordPress website via the web site’s database! Be sure you are following our Facebook and Twitter pages to stay up to date with the latest in webmaster tips, updates for web software, everything x10Hosting, and more!