BUMMER so you forgot your WP-Admin Username or Password for your website on aquaponics (AWESOME niche FREEBIE by the way….RUN with it people!) that you haven’t visited in awhile, and the WP ‘Lost Password’ Automatic Emailer is NOT working for you…..now what? How are you going to get in and write that brand new post on a killer new tank you just found?
Relax, would I ever leave you hanging? I’m going to show you how to manually reset those through phpMyAdmin on the backend. This post comes to you courtesy of my sister who drives me nuts with this frequently, so she will be learning right alongside all of you how to do this herself; which I can tell she’s just thrilled about by the way.
Hopefully you have your CPanel login information handy because you’ll need it. If you’ve lost that information too then I am really sorry but it’s time for you to give up…….SIT BACK DOWN, DON’T EVER GIVE UP! I’m going to share one of my greatest beliefs with you.
The only difference between 100% of all the people who FAIL at something versus 100% of all the people who SUCCEED at it is……READY……. Those who SUCCEED never GIVE UP AND QUIT! If what you are doing is NOT working then find another way to do it, find someone to help you do it, adopt a mentor to guide and teach you how to do it, do whatever it takes, BUT DON’T EVER GIVE UP! …… DON’T EVER GIVE UP! …… DON’T EVER GIVE UP! Pep talk over!
Seriously if you did in fact lose your CPanel login information then email your hosting company and have them help you. If you forgot who your hosting company is (SIGH) then hop on over to my contact me page top right hand corner directly above and contact me, I’ll give you a little one-on-one help. Moving ON!
Login to CPanel and navigate down to the Databases section and click on phpMyAdmin.
NOW, I’m a firm believer in better to be SAFE than SORRY, so stop everything right now and make a complete backup of your website and database. This way if something goes horribly wrong you can always restore it. I’m not going to show you how to do that right now because I already wrote a post on How to Backup a WordPress Site that you can read and follow along with.
All backed-up? Great let’s get to it.
You should still be in phpMyAdmin, so locate the database for your website on the left hand panel of your screen and click on it. Make sure the Structure tab is selected on the right hand side of the screen and below you should see a listing of all your database tables.
Scroll down to the users table which will have the default prefix of WP_ if you do not change it for security purposes like I do, and click on it or hit Browse next to it.
Click Edit to update the table with your new user information.
Find user_login and scroll to the right where you will see your current user name. If you’ve forgotten what it is but remember your password you should now be able to login into your wordpress site with the username shown.
If you’ve forgotten your password you’ll need to reset it. Find user_pass and scroll to the right where you will see your current password which will be a long funny looking string. You’ll have to reset it so select that long string and delete it. In the box type in your new password as you normally would, REMEMBER it’s case sensitive and make sure to write it down somewhere.
Click on the dropdown box next to user_pass / varchar(64) and select MD5 from the menu.
Click the ‘Go’ button at the bottom, and test, you should now be able to login to your WP-Admin page with your recovered user name and your new reset password.
That’s it……easy stuff right? It’s good to know how to do, after all it happens to the best of us, losing passwords or forgetting a username it’s part of our online world; but you are now one very important step above so many others out there! AND I for one am THRILLED that I don’t have to do this every other day for my sister who should now be able to do this herself just like all of you, which makes me one very happy person!
As always let me know your thoughts or problems in the comments section.