How to change a WordPress password through phpMyAdmin

Locked out of your WordPress website? Here’s a quick guide on how to change your WordPress password through your phpMyAdmin database.

Change the WordPress password using phpMyAdmin

In order to change a WordPress user’s password, you need to follow the following steps accordingly:

1. Login to phpMyAdmin

2. Find your wp_user‘s table

3. Edit the user’s data

4. Enter a new password and select the MD5 function to encrypt it

Change the password using an SQL command

If you don’t have access to phpMyAdmin, you can use the command below to reset your user’s password accordingly.

UPDATE 'wp_users' SET 'user_pass' = MD5( 'examplepassword' ) WHERE 'wp_users'.'user_login' = "exampleadmin";