How to reset the WordPress Admin Password through an SQL Query
It happens many a times that we tend to forget passwords! WordPress passwords aren’t any different – In case you forget your admin dashboard login password and would like to recover it, the only option from the front end is to use the “forgot password” link. In case you even forgot the email ID used or the password to recover that, you still have a way out!
Login to your webhosting Cpanel (reset that from your web host if you are not sure of that one also) and open the program called PhpMyAdmin. This allows you to access the database on which the WordPress blog is created on, simply click on the Database name and on the top panels you should find a “SQL” tab on the window as shown below. All you have to do is paste the below query and replace the “newpassword” with the one of your choice and it resets the admin password to the new one of your choice.
UPDATE ‘wp_users’ SET ‘user_pass’ = MD5(‘NewPassword’) WHERE ‘user_login’ =’admin’ LIMIT 1;
Now, you may try to login to your admin with the newly configured password before you forget that one 😉 Wishing you all the best, hope this small tip has helped you get back in business. Let me know in case you have any difficulties resetting your WordPress admin password.