Post Pic

How to: Manually reset your WordPress password

What to do if you lost your WordPress password? The easier is to use PhpMyAdmin and execute a simple SQL query to update it. Here’s how to proceed.

To achieve this recipe, login to your PhpMyAdmin, select your WordPress database and click on the "SQL" button to open the SQL query window.

Then, paste the following code in the window textarea. 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;

CRedits goes to Ditii for this awesome recipe!

Related Posts

Related Posts

No related posts.

Leave a Comment

* Name, Email, Comment are Required

WP Theme of the week

Punk rock anyone?