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.
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’;
Hits: 737