N/APosted on - 12/23/2014
Hi there, I'm new to WordPress and just forgot my admin password…
Is it possible to execute some MySQL statement in order to reset the password?
I do have access to phpMyAdmin.
Thank you for your help.
How can I recover my WordPress password?
Yes, you can reset it through phpMyAdmin. Its the easiest way.
Login to phpMyAdmin, select your WordPress database.
From the structure, look up for wp_users.
Click browse icon there.
Under the user_login locate your username.
Click on Pencil icon for editing it.
When user_id shown, click edit.
Delete the old password and type your new password. Remember its case sensitive.
From the drop down MENU select MD5.
Click the GO button below and you are done.
Here is the url for details.