SQL Query to Update Forgotten Password in WordPress

Posted on January 24, 2018March 28, 2019 by Darryl Erentzen

It’s pretty simple. You just execute the following query:

UPDATE wp_users SET user_pass= MD5('PASSWORD_HERE') WHERE user_login='USERNAME_HERE';

You could also go:
UPDATE wp_users SET user_pass= MD5('PASSWORD_HERE') WHERE ID='ID_HERE';

Or:
UPDATE wp_users SET user_pass= MD5('PASSWORD_HERE') WHERE user_email='EMAIL_HERE';

Etc., you get the idea.

Whatever field you use as your identifier, make sure the values are unique. There are plugins out there that allow the same email to be used for multiple accounts, so watch out for that last one. ‘ID’ or ‘user_login’ are safest.

0 people found this article useful

Darryl Erentzen has written 42 articles

Darryl Erentzen is a 20+ year veteran of the web and web development. He has worked on almost every conceivable platform in just about every programming or scripting language to percolate through the internet in the past 20 years.

Most recently, Darryl has leveraged open source software to provide information architecture. systems integration and development leadership to companies big and small - developing custom solutions for business with an incidental focus on delivering MVPs for start-ups, providing cost-effective rapid application development for MVPs and proof of concepts.

Typical deliverables include AJAX-enabled web applications to enhance workflow and engagement, integration with existing business processes, and both public-facing and internal solutions.

While based in Manhattan in the early days of his career, Darryl managed and evolved Thing.NET which served the International Fine Arts community. The thing.net initiative was supported by HP and SGI and served websites for well-known art concerns including Artforum magazine, PS1, Museum of Modern Art.

Working with Fusebox.com, Darryl designed and deployed solutions for NickelOdeon, Time-Warner Cable, Chase Manhattan Corporation, CBGB, and a variety of web properties, from small businesses to multinational corporations.

As founder and CEO of Web Plant, a web development firm based out of Toronto, Darryl managed the successful development of a number of high profile web projects for internationally known brands including Panasonic, Hewlett-Packard, Microsoft, Pontiac and others.

Darryl Erentzen has written 42 articles

Leave a Reply