How to I retrieve my WP admin password.

asked Mar 4, 2013 in General by Dan_31 (910 points)
I forgot my WP admin password, and I can’t reset the password because I also don’t remember the password of the email associated with this WP admin user. I am using phpMyAdmin and I was wondering if I can retrieve the password from there am a complete novice. I have forgot my wordpress admin password. How can I reset my password through phpmyadmin?
Any help would be appreciated
Many thanks

2 Answers

0 like 0 dislike
answered Mar 4, 2013 by ZakWeb (3,880 points)
From your phpmyadmin, go to the wp_user table and edit the entry for admin user, user_pass select  MD5 and then type is your new password and click go to save.
0 like 0 dislike
answered Mar 4, 2013 by WebProX (12,200 points)
From your phomyadmin, locate the db and then go to "wp-user". Select the first row and go to edit, and the username will be listed under the "user_login". Go to "user_pass"  option and put your password under the Value option, and  select MD5 from the Function option. Then click Go to save.