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.

© 2021 WPOven Inc. All rights reserved. WPOven® and WordPress® are registered trademarks.
WPOven INC is more than just a managed WordPress Hosting that offers more secured unlimited website hosting with it’s CDN ready worldwide Datacentres.
linkedin facebook pinterest youtube rss twitter instagram facebook-blank rss-blank linkedin-blank pinterest youtube twitter instagram