Ever lost your password to your WordPress setup and couldn’t login because the password reset mail took its time to arrive? Maybe you didn’t lose your password but wanted to configure Cloudflare’s Universal SSL on your site and your login process got stuck in a redirect loop?

Yet you urgently need to login to WordPress and there’s no other admin account available to resort to. Fear not, with access to your database you can easily fix the issue and overwrite your WordPress user password.

Most likely your hosting platform will have cPanel, complete with phpMyAdmin, making this process easy and definitely less daunting for most users than doing this via SSH/command line would be.

How to Reset a WordPress Password in the Database

Important: We recommend everybody to first backup their database – and also WordPress files – before proceeding.

Select the users table in your database.

First of all, you will need into your cPanel account[1^], and then proceed the phpMyAdmin section.

Alternatively you could proceed with a WordPress plugin which allows you to execute SQL commands from within your WP admin area, such as SQL Executioner or the popular WP DBManager.

In your phpMyAdmin, find the database used for your WordPress installation and navigate to the users table.

In the users table, find the user you wish to change the password for and double click on their password, in the user_pass column. Now you can change the password for that user account.

But… plaintext?

WordPress doesn’t store password in plaintext in the database, instead they are stored as a MD5 hash. Thus you will first have to hash the new password before entering it in the database.

There are many free MD5 hash generators available online and most are easily accessible via your preferred search engine.

Here at rockingWP, usually we use TimeStampGenerator’s MD5 tool.

Once you have generated the MD5 hash for the new password you wish to use, paste this hash in the appropriate field in the user_pass column for that user and hit Enter.

The user_pass column in your users database table.

That’s all there is to it, you can now login with to your WordPress installation with the new password.