Email-Icon Created with Sketch. Group 3 Created with Sketch. Domains-SVG-Box Created with Sketch. Domains-SVG-Box Created with Sketch. Domains-SVG-Box Created with Sketch. Hosting-SVG-Box Created with Sketch. Hosting-SVG-Box Created with Sketch. Icon-Internet Created with Sketch. Hosting-SVG-Box Created with Sketch. Icon-Internet Created with Sketch. Icon-Internet Created with Sketch. Hosting-SVG-Box Created with Sketch. Hosting-SVG-Box Created with Sketch. Trust Pilot Stars Created with Sketch. 1-5-million Created with Sketch. Control-panel-Icon Created with Sketch. WSB-Brush Created with Sketch. WSB-Brush Created with Sketch. WSB-Brush Created with Sketch. Email-Icon Created with Sketch. Email-Icon Created with Sketch. Email-Icon Created with Sketch. Email-Icon Created with Sketch. Icon-ECommerce-Seperator Created with Sketch. Icon-ECommerce-Seperator Created with Sketch. Icon-ECommerce-Seperator Created with Sketch. icon-slider-next Created with Sketch. icon-slider-prev Created with Sketch. Webmail-icon Created with Sketch. heart Created with Sketch. Open-24-7 Created with Sketch. open24 Created with Sketch. 24 7 trusted Created with Sketch. Fill 1 Created with Sketch.

Change your WordPress password in the database

Normally you can reset your WordPress password in the dashboard or request a new one via email. In case you have no access to both your email and the WordPress dashboard, you can change your password directly in the database.

Step 1 - Access your database in PHPMyAdmin
Step 2 - Open the users table
Step 3 - Enter new password
Step 4 - You are done!

Step 1 - Access your database in PHPMyAdmin

Read our guide on how to access your database if you would like some help.


Step 2 - Open the users table

  1. Click the users table in the menu to the left. The table can have different prefixes, in this example it is www_.
  2. Locate the user for which you want to change the password and click Edit.
Open the table called wp-users

Step 3 - Enter new password

  1. Next to user_pass choose MD5 from the drop down menu under Function.
  2. Under Value replace the current encrypted password with the new password. You can type normal text, it will be encrypted after saving.
  3. Click Go to save your changes.
Type your new WordPress password

Step 4 - You are done!

Your new password has been saved and encrypted. It can now be used to login to WordPress.

WordPress password changed

Related articles:

Update WordPress database connection details
Change your WordPress theme from the database
Disable WordPress plugins in phpMyAdmin