WP-Mix

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

WordPress Resources

[ USP Pro - User Submitted Posts ] [ SAC Pro: WordPress Chat Plugin ] [ Digging Into WordPress ] [ GA Pro: WordPress + Google Analytics ] [ The Tao of WordPress ] [ Wizard’s Collection: SQL Recipes for WordPress ]

Subscribe to WP-Mix

Project Demos

Popular Posts

Recent Posts

Random Posts

RSS Feed

Grab the RSS Feed ›

1500 readers
Feed Statistics
About the Author

Jeff Starr is a professional developer, designer, author, and publisher with over 15 years of experience. He writes books and tutorials, develops plugins, and runs his own business.

About the Site

WP-Mix is where I share code snippets, tricks, and tips. WP-Mix was launched in October 2012, and now features 414 posts. You can check out the latest post published on Aug 29, 2024. Learn more ›

Contact

A few ways to connect:

© 2012–2024 Monzilla Media ★ shapeSpace ★ Sitemap ★ Feed ★ Privacy ★ Made in the USA