Things do happen. What happens when you lost your password or even worse, lost the password of the admin account because it’s been so long? Yes, you can use the “Forget Password” feature to reset your password. But what if even that doesn’t work?
Here is a quick way that we can use to update the wp_users table value to reset any account’s password.
Log into MySQL first.
$> mysql -u room -p
Type the password of the root account and press Enter to get in.
Then switch to the database that hosts your WordPress website.
mysql> USE wp_db_name
Now, run the following update command to update the account’s password.
mysql> UPDATE `wp_users` SET `user_pass`= MD5('yourpassword') WHERE `user_login`='yourusername';
That’s it. If everything goes as planned, you will have a new password for your lost account right after.