UnixServerAdmin

Server Administration & Management

How to reset WordPress administrator password

Sometime you may need to reset your admin password for your WordPress blog. You have to reset your password through the WordPress database directly in case if the forgot password doesn’t work. The most convenient way to manage the database is via the PhpMyAdmin tool at your web hosting account.

In PhpMyAdmin, select your WordPress database from the drop-down menu on the left. The page will refresh and the database’s tables will be displayed on it. Open the SQL tab (look at the top navigation bar).

In the text field write the following SQL query:

UPDATE `wp_users` SET `user_pass` = MD5( ‘your_new_password’ ) WHERE `wp_users`.`user_login` = “your_admin_username”;

“your_new_password” – replace this with the new password you wish to use.
“your_admin_username” – replace this with the username the password should be updated for.

Once you are ready, click on the “GO” button to submit the query. If everything goes fine without errors, you should be able to login to WordPress with the new password

Advertisements

January 19, 2011 - Posted by | WordPress | ,

2 Comments »

  1. This really is a amazing article. Thank you for making the effort to describe all this out for folks. It truly is a great guide!

    Comment by Mozella Kumalaa | June 15, 2011 | Reply

  2. Are you clairvoyant? You must be as your blogging so correctly satisfies the questions I possess for this topic. I only entered several phrases in the google search and I am very fortunate your article popped up.

    Comment by fresh water | June 16, 2011 | Reply


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: