PDA

View Full Version : How to manually reset Wordpress password using MySQL database (PHPMyAdmin)



Fli
07-16-2024, 07:29 AM
When one checks a MySQL database manager PHPMyAdmin, click database, click users table, find proper user, there is a md5 hash of the password inside the user_pass column.
So one can change this manually.

A) running command of this type:

UPDATE `wp_users` SET `user_pass`= MD5('changeme') WHERE `user_login`='admin';
(note that it is ran on the username "admin" and new password is "changeme")

B) try doubleclicking the user_pass column and replace its content by (no spaces): 4cb9c8a8048fd02294477fcb1a41191a
then login using password: changeme