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

[ The Tao of WordPress ] [ SAC Pro: WordPress Chat Plugin ] [ WordPress Themes In Depth ] [ BBQ Pro: Advanced WordPress Firewall ] [ Banhammer Pro: Hammer the Enemy ] [ 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 ›

1435 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 409 posts. You can check out the latest post published on May 2, 2023. Learn more ›

Contact

A few ways to connect:

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