Quick tip o the day! Here’s how to reset your password using a simple SQL query.
Log into phpMyAdmin or anywhere else you can query the database, and enter the following SQL query:
UPDATE 'wp_users' SET 'user_pass' = MD5('PASSWORD') WHERE 'user_login' ='admin' LIMIT 1;
Remember to backup your database before making any changes. Note: if it’s not working, check the “wp_” database prefix; it’s common to change it to something else.