Reset Your WordPress Admin Password via phpMyAdmin

Have you forgotten your WordPress Admin password? Did you lose access to your WordPress because you fell prey to the WP password vulnerability and your p/w got hacked? (Problem now corrected with WordPress 2.8.4). Take heart, your password can be reset outside of WordPress by using phpMyAdmin.

CAUTION!

phpMyAdmin allows you to directly edit your WordPress database! You can totally and permanently ruin your WordPress installation and have to start it all over again. While I have attempted to make this tutorial easy-to-follow and and accomplish, I take no responsibility for any problems that may occur from your modification of your WordPress database. If you are not comfortable with attempting to work on your WP database yourself, find someone technically competent to assist you in restoring your password.

When you set up your webhosting, your host likely gave you a login and password to your account. This would be the place where you set up your email addresses and the like. Most webhosting companies use CPanel as an interface. CPanel makes life much easier!

Anyway, you want to log onto your hosting account and find phpMyAdmin and click it.

Here’s what it looks like in my CPanel…

Click on phpMyAdmin to open the program in your browser. If your phpMyAdmin is the current version (as of this writing), you should see this…

Click on your WordPress database. You should see the following…

Scroll down to find the row named “wp_users” and click on the “Browse” icon. This will take you to the next screen…

Find the row for the “admin” user and click on the pencil icon to edit the admin password…

Locate the “user_pass” row in the field column. In the “Function” column of that row, click on the dropdown list and select “MD5″. Continue to the “Value” column. What you will see there is an encrypted version of the current password. Click on it and remove it so that there is nothing in that box. Now, enter the password that you want to use for the “admin” account. Don’t worry that it isn’t encrypted, that will be taken care of automatically. Lastly, at the bottom of this last screen, be sure to clock on “Go” to save your change of password.