Reset WordPress Admin Password via SQL or phpMyAdmin

Written by Rahul, Updated on December 5, 2017

Question – How to reset WordPress admin password via SQL query? How to reset WordPress admin password using phpMyAdmin? How to Reset WordPress forgotten password with SQL query? How to find WordPress default admin password?

If you have forgotten your SugarCRM admin password or due to any reason, you are not able to login to SugarCRM with admin user. You can simply check the active admin user using SQL query and reset the password with simple SQL query.

Reset WordPress Admin Password via SQL

The first query will fetch show the details of the administrator account based on username.

SELECT * FROM wp_users WHERE user_login = 'admin';

1	SELECT * FROM wp_users WHERE user_login = 'admin';

If you only have the email address of admin user. Search user details using the command.

SELECT * FROM wp_users WHERE user_email = 'admin@example.com';

1	SELECT * FROM wp_users WHERE user_email = '[email protected]';

WordPress uses md5 encrypted passwords. The query will change the password for the specified username. You must change new_password with your password and ID with the got ID from above queries.

UPDATE wp_users SET user_pass = md5('new_password') WHERE ID = 1;

1	UPDATE wp_users SET user_pass = md5('new_password') WHERE ID = 1;

Reset WordPress Admin Password via phpMyAdmin

You can also connect WordPress database with phpMyAdmin and reset the admin password. Open table wp_users and edit the record of the admin user. Now under the user_pass column, select the MD5 in functions and put plain text password in value section and save it.

Reset WordPress Admin Password via SQL

Reset WordPress Admin Password via phpMyAdmin

Rahul

Leave a Reply Cancel reply