Just imagine.. You have a wordpress blog, and for some reason, you cannot login as admin user to your wordpress blog?

You tried the forget password utility, but dont get through the password reset feature and now clueless..

Then it might be time to change that information using WordPress’ database.

Even if you don’t have CPanel, you should have access to phpMyAdmin. It is a simple, but powerful, application that allows you control over your databases, and can be easily used to change all kinds of information stored in the MySQL databases it manages.

1) Login to your phpmyadmin and search for the database that holds your wordpress data. You can login to phpmyadmin as root user, or with the mysql user that has access to your databases.

2) A new window will most likely have opened. It will have two panes. On the left hand side you will have a list of databases. Click on the one related to the WordPress installation we are going to work with.

Look for a table called wp_users in the left hand pane. It is usually the last item in the list.

*Note: If your WordPress table prefix is not wp_ then you will be of course looking for your custom prefix user table. You can find your prefix in the wp-config.php file.

Click on the user table link, and in the right hand pane, the information will change. At the top there should be a few links. Click Browse.

It should then look something like the following image.

3) Now is the time to reset your password. Please remember, WordPress stores the passwords as MD5 hash. You will notice there is a field called user_pass. This is where the password is stored in WordPress. Find the user you want to edit, and click the pencil image next to the red X. This will allow us to edit the entry.

You will notice the password is strange, and not plain text. This is because for security reasons, as passwords are in MD5 has format.

We can’t just enter a normal text password, and should replace the MD5 hash of the password we don’t know with the MD5 hash of a password we do know.

To create an MD5 hash, I usually just search for “online MD5 hash” on Google, and come up with some great online tools for creating the result I need.

In such tools, I enter what I want the password to be, click a button to process it, and it spits out the MD5 hash that I want to enter in the user_pass field.

Click Go to save the change, and then log in to WordPress using your new password.