If you’re anything like me and a great many other people nowadays, you’ll have a multitude of passwords to remember for just about everything in your life and despite promises it’s just not so simples to get and stay organised with their management. Then the inevitable happens and you forget one. When it’s your admin password to your WordPress site you have a problem.
Here’s a simple way to resolve the problem (of course, it requires that you have access to another password – that for your webhosting package – another password, I know, I know (and if you lose one, well, why not another).
WordPress is built around a database that you’ll have configured before installing WordPress for your website/blog.
This article explains how to reset a lost WordPress password using phpMyAdmin. I’ve concentrated on the admin password in this short article (because that’s the password I had lost) but the steps apply to any password for any user of your WordPress site/blog.
You Will Need..
To perform this task you will need the following Items.
- The name of your WordPress database.
- Access to phpMyAdmi, probably through your host
- Once logged into your hosting package admin portal go to the databases area e.g. group of icons or menu area on the portal page and click on phpMyAdmin
- (depending on your hosting package you may have to login again at this point – if so, when prompted login with your host package username and password).
- From the list of databases, select the database you use for the WordPress site in question.
Enter a New Password…
These steps explain how to change the password in the database.
- In the list of tables in your database, click on the “users table” – this will have a prefix “wp_” and may have other characters after that depending on whether you configured the prefix when setting up WordPress in the beginning.
- Click “edit” next to the user you want to set the password for.
- Enter the new password into the password box
- In the function box next to the password choose MD5
- Click Go
That’s it, the password has been reset. You can now login to WordPress with your new password.
There you go, it’s that easy. Of course it relies on you being able to login to your hosting portal provided by your host – that of course involves using a password. If you’ve forgotten that one you’ll have a different password recovery process to go through before you can start the procedure summarised here. It’s good advice to invest in a password manager of your choice and log all your passwords in there with some sort of organisational structure for quick/easy retrieval.