How to Manually Update Wordpress Passwords via phpMyAdmin

In WordPress, there is more than one way to reset a password. Under normal circumstances, you can reset the password by using the Forgot Password link on the login page. If this is not working for any reason, you can connect to your Wordpress database via phpMyAdmin to manually reset it to something else.

This article assumes that you are already familiar with how to log in to the customer control panel. If you do not know how to log in or have forgotten your password, please refer to this article first. We strongly suggest backing up your Database prior to making any changes. 

• On the control panel Home tab, click "Databases" under the Databases & Backups section.

• Click on the name of your Database in question. If you do not know which database is used by WordPress, you can check your wp-config.php file, as it will be listed there. 

• Click the link labeled "Browse Database Manager" to log in to phpMyAdmin.

• Select your database name from the left navigation menu. Then, click on the wp_users table. Note: This table may have a different prefix than "wp", but this will depend on what settings were configured when WordPress was installed on your website. The correct table name should always end in "_users", so look for this if "wp_users" is not an option.
  

• Find the user for which you need to change the password, then click the Edit button to its left.
  

• Find the "user_pass" option and enter your new password in the Value column. Under the Function column, select MD5 -- this is the encryption type which will protect your password. Click the Go button to finalize your password reset.
  

If you have any further questions that were not answered in this article, please contact us.