Knowledgebase: MySQL

How to Manually Update Wordpress Passwords via phpMyAdmin

Posted by Justin Davis on August 31 2015 05:24 PM

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. 

Database Select

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

Browse Database

  • 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.

Open Table

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

Edit User

  • 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.

Change Password

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

 

 


Copyright © 2016 HostMySite