SysAdmin

How to Reset wordpress admin password via MySQL query or PhpMyadmin

JJ
Jobin Joseph · Founder and CEO
·Published 29 October 2013·1 min read

This is how you can reset the password of your wordpress admin user.

– Connect to your wordpress database via phpmyadmin or mysql-clients like sqlyog
– Select the database and get ready to run the following query.

UPDATE `wp_users` SET `user_pass` = MD5( ‘newpassword’ ) WHERE `wp_users`.`user_login` = “admin”;

– Now you can login to the http://yoursite.com/wp-admin with username admin and password newpassword
– Of course, You can change the newpassword to anything on the mysql query to as you like .

Like and share if found helpful

Jobin Joseph
Jobin Joseph, Founder and CEO
5x AWS Certified, ISO 27001:2022 Lead Implementer, 17+ years building cloud infrastructure for regulated industries.
About Jobin →

Reading this because your AWS bill or uptime is a problem?

30 minutes, direct with the founder, no sales pitch: one specific recommendation for your AWS workload.

Book a free 30-minute review
30 min Free Consultation →