Changing Username and Password

For some odd reason I've seen an increase in the number of threads at the forums from people unable to login to their WordPress install. I'm not sure if they have simply forgotten their login details or if the information in the database was somehow corrupted but the threads are very real. If you find you cannot login to WordPress because you forgot either your username or password you can still reset everything in the database via phpMyAdmin. Actually it's a good idea to change your username anyway. WordPress by default sets the admin account username to admin - how original. That's half the information any potential hacker needs right there. While changing the password can be accomplished from within WordPress itself changing the username cannot.

Login to whatever control panel your host offers such as cPanel. Next, login to phpMyAdmin.

2008-04-17_2002

1. Once you're signed into phpMyAdmin you will see a screen similar to the one above. (click image to enlarge) Select your database from the list.

2008-04-17_2013

2. Now you will see the screen above. (click to enlarge) In the wp_users table click the "browse" icon.

2008-04-17_2014

3. At this screen (click to enlarge) you need to click the pencil icon which means edit.

2008-04-17_2019

You will now come to this screen. (click to enlarge) These are the final steps. Type your new username and password in the boxes illustrated above. After typing in your new password be sure to click the drop down menu and select the MD5 password hashing option. WordPress 2.5 uses an improved hashing algorithm but you can still choose MD5. The first time you login to WordPress the password will be converted using the new algorithm. After you have done all of that click "Go" to complete the procedure.

Test to make sure everything works the way it should by logging into WordPress.

Below is a short video screencast.

Editor's Note: The video screencast has been updated for WordPress 3.1.2 and is now in HD.
Post Updated: 09 May 2011

If you prefer to view it directly on YouTube click here.

About Len Kutchma

Len has been blogging for over 10 years and is a rabid WordPress fan. In addition to blogging here you can find him writing the occasional article and toiling away in the forums at WeblogToolsCollection.com. He also hangs out at the WordPress support forums lending a hand where he can. Be sure to follow @wpcanada on Twitter.

Comments

  1. shawn says:

    Thanks! You saved me.

  2. Len Kutchma says:

    You're most welcome Shawn!

  3. Kyle says:

    New to this, and this really helped me out. Thanks.

  4. Len Kutchma says:

    Glad you found it useful Kyle.

  5. Tilly Holmes says:

    It is also easy to backup and transfer all your websites from one server to another server if you have cPanel installed.

Please Note: WPCanada is a moderated community. Please read the Comment Policy.

HAVE SOMETHING TO SAY?

*