Manually reset your WordPress password

What to do if you lost your WordPress password? The easier is to use PhpMyAdmin to update it.

If you’ve only single user on your WordPress installation, and the login name is admin. You can reset password with just simple SQL query, which once executed will replace password with whatever you enter as your new password to be.

Don’t forget to modify the password and username before executing it. Also, make sure you have a backup of your database before executing any SQL queries to your database.

UPDATE 'wp_users' SET 'user_pass' = MD5('PASSWORD') WHERE 'user_login' ='admin' LIMIT 1;