Update user / admin password via database

WordPress: Update user / admin password via database

Forgot your WordPress admin login details or a previous developer is unwilling to give you the WordPress login details, well the answer is very simple. As long as you have database access you can use the website below to generate a new password hashsum, simply replace the origional password value with the new hashsum and you will have access again.


The following query will update the main admin password. Add your hashsum and update ID to the required user ID you with to update.

Use the following select query to retrieve all WordPress users and there ID

Alternativly you can change the users email address via the database and perform the password reset, however this can be a bit annoying if all you want to do is update the password as you then have to change the email back.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.