WordPress Code Snippets

A fresh mix of code snippets and tutorials

Reset password via SQL

40

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.

Learn more

WordPress Themes In Depth


Show Support

Like our new Facebook Page to show support!