How to reset wordpress password
October 6th, 2009
Please go through the following steps to reset any password for wordpress blog from the mysql prompt. Make s
1). Get an MD5 hash of your password. (This should be done from the shell prompt not from mysql prompt)
On Unix: echo -n <password> | md5sum
2). use (name-of-database);
3). show tables;
4). SELECT ID, user_login, user_pass FROM (name-of-table-you-found);
5). UPDATE (name-of-table-you-found) SET user_pass=”(MD5-string-you-made)” WHERE ID = (id#-of-account-you-are-reseting-password-for);
6). And finally confirm that the password has been changed with the command given below
SELECT ID, user_login, user_pass FROM (name-of-table-you-found);