WordPress login password reset

Problem

You cannot remember your password for your wordpress site, but you do have access to the PHPMySQL admin or access to MySQL using any tool e.g. Toad.

myiten_pass1

Solution

Log into the database
Run the following command assuming your word press prefix is “wp”, replacing “yournewpassword” with your new password and “yourusername” with your actual user name

UPDATE `wp_users` SET `user_pass`= MD5(‘yournewpassword’) WHERE `user_login`=’yourusername’;

myiten_pass2

myiten_pass3

Hits: 10

Leave a Reply