How to Update the WordPress User Password from the Database?

reset wordpress password phpmyadmin

If you have forgotten your WordPress user password and wish to update it, you can do so directly via the Database.
Step 1 : You would require access to your WordPress database. You can access the database via any database manager like PHPMyAdmin or Adminer. For this tutorial, we will be using Adminer Database Manager.

Step 2 : Login to your database and Open the 'WP_Users' table.

Step 3 : Edit the row corresponding to the user whose password you wish to change.

Step 4 : Create a MD5 Hash Encrypted string of the new Password. You can create a MD5 hash string using one of the many MD5 hash generators like Danstools.com or Miracle Salad

Step 5 : Enter the New Password MD5 string in the Password column and press 'Save'.

You WordPress user password is now updated.

WPOven
© 2024 WPOven Inc. All rights reserved. WPOven® and WordPress® are registered trademarks.
WPOven is the best Managed WordPress hosting for agencies and businesses that want to succeed. With Unlimited sites hosting option, its easy to use and manage, so you can focus on growing your business. 
linkedin facebook pinterest youtube rss twitter instagram facebook-blank rss-blank linkedin-blank pinterest youtube twitter instagram