A fresh mix of code snippets and tutorials

Reset password via SQL

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

Digging Into WordPressWordPress Themes In DepthWizard’s SQL Recipes for WordPress