Wordpress Tutorials

Sometimes We forget user names and sometimes we forget password. Well, last night when I loged-in to my locally hosted WordPress on my Computer I found I’ve forgotten my password. I asked my friend to fix that for me and I thought why not share with my readers How to change forgotten password from phpmyadmin.. though we can reset the password by email address, but in some cases we don’t have an email too.

Well, this is how its done.

Find the Password:

• Log in to your PhpMyAdmin.
• Select your WordPress Database
• Click on wp_users
• Select SQL tab from top navigation
• In “RUN SQL Query Database” box, some text will be already written as:
• SELECT * FROM `wp_users` WHERE 1
• replace WHERE 1 with a semicolon; – the code will now look like
• SELECT * FROM `wp_users` ;
• Press Go

A list with all usernames will generate. You can see password for every username next to it.

How to change the Password:

• Go back to same screen where to added semi colon.
• Replace all text with

• Update wp_users set user_pass = md5(‘password’) where id=1;

• ID  = ID of the selected username
• password = enter your desired password

Now you can login back to http://yourdomainname/wp-admin/ with the new password.

Enjoy !

P.S:

Please don’t try to take advantage of this trick and change or see password of your blogging partners.

This post was written with the contributon of my coder friend Akram Kamboh. Who works at GEXTON as a Programmer and Developer.

Related posts:

1. How to Change the Default Gravatar in WordPress
2. Post more ?
3. WordPress Responds to Attack: “Please Upgrade”