T U T O R I A L S E R I E S

phpMyAdmin

Here's how to change your password using phpmyadmin.

Warning ! phpMyAdmin is a powerful tool - Use with care. If you have any doubts at all, please seek further advice. I will not be held responsible for any loss of data.

A list of your databases will appear. Click the one that is your WordPress database.

All the tables in your database will appear.
Click on the small icon indicated. Hovering this icon should show the word 'browse'.

The next screen will show who is registered on your blog.
You need to look at the top line there. User ID #1 is you - the blog owner. You will see your login name, then a long string of letters and numbers. That's your password.

Click the pen icon.

Now you see all the details associated with that user.
Across from the 'user_pass' is your encoded password.

Delete that long string of characters.
Now type in the password you want to use. Just type it in normally, but remember, it is case-sensitive.
In this example, my new password will be 'carrots' (1)
Once you have done that, click the dropdown menu indicated, and select MD5 from the menu. (2)

Now check that your password is actually correct, and that MD5 is in the box.

All good ? Click the 'Go' button to the bottom right.

You have returned to a screen you were at earlier. Note that your password has changed.

Now go back to your blog's login screen, and hopefully now all is well.