Reset your WordPress Admin Password When You Cannot Access Your WordPress Dashboard

When you have too many websites like me, sometimes you have to reset your WordPress admin password. Yes this happens to me all of the time.

Normal people can simply click on the “forgot password’ link, but I often do not even know the email address I have actually used. I know this sounds crazy, but I am sure you will have your own reasons for needing to read this tutorial.

How to Reset your WordPress Admin Password?

Yes you can reset your WordPress admin password but you will need a few things first.

What do you need to change your WordPress admin password?

  1. To reset your WordPress admin password you will need access to your server. This is the website hosting where your website is located. For example, I use Hostgator for my website hosting and would go to my Cpanel to change this password.
  2. If you are hosting more than one website in the same location you will need to know the database name that particular website you want to log into.
  3. You will need to have access to the Internet to login to your server and to create a new MD5 encryption.
  4. You will need to open a notepad so you can copy your new MD5 encryption password, and to note what this code interprets to.

Basically you should have all these things if you are running a website. We all need an Internet connection if we are involved with websites.

How to reset your admin password for WordPress

I have made a detailed video tutorial on how to reset your admin password but I will also list a quick set of instructions.

1. Login to your server Cpanel and look for the databases section. Look for the phpMyAdmin icon.
2. Double-click on this icon to enter. See the screenshot below.

3. Once in phpMyAdmin select the WordPress database from the drop-down menu on the left. If you are not sure which database to choose, scroll down below to find the instructions on how to see which database you are using.

4. Then when you have entered the right database, you need to look for the username. This will be the account that you want to change the password for.

5. You will then need to click on the edit link to actually change the details for this user. See this screenshot below.

6. Now you will see more details and be able to change them. Where it says user_pass, this means we need to change these details.

7. Go to Google and type in MD5 encryption or you can try this MD5 hash website. You will need to generate a new encrypted user password.

8. Once you have generated a new encrypted password, paste it into the user password section.

9. Click on the GO button to submit the query.

The best way to learn how to change your WordPress admin password is to watch the video below.

How To Find Your WordPress Data Base Name?

Lets say you have 20 websites installed on your Hostgator server. This creates a small problem when trying to edit the data base user details as you need to know which data base to enter. You could enter them all until you see something that looks familiar but this is a waste of time. Before going to the phpMyAdmin section in your hosting, you need to go to the root of your domain and look for your wp-config.php file.

1. Login to your cpanel hosting.
2. Scroll down to the files section and look for the file manager icon. Double-click on that icon. See the screenshot below.

3. A file manager directory selection box will appear. You will need to make a few choices here.

  • you need to select document root for:
  • You need to tick the box that says show hidden files.
  • You need to choose which website from the drop down menu.

After all of this you can press the go. See the screenshot below.

4. Now you can look for your wp-config.php file and select it by making it blue.

5. Then right click on the blue selection and choose “view” from the menu.

6. In this file you should see something like ” (‘DB_NAME’, ‘mydb_wrdp30′);

7. That means that mydb_wrdp30 is my database name.
If you have problems resetting the password yourself, ask your website hosting company for help. I’d definitely know that Hostgator would help out in a situation like this as I have always got fantastic help from them, even though the problem had nothing to do with their hosting.

 

Comments

  1. Nadia Barbara says

    This is a very helpful post Mitch! I guess it is inevitable for a blogger to forget their password especially if they are handling multiple blogs or website. This tutorial has helped me a lot. :)
    Nadia Barbara recently posted..SEO Tip: Google Analytics

  2. Jeremy says

    Hah that’s a useful unformation for me as I always forget my passwords, not only WordPress ones and I also use different e-mail addresses) But I’m trying to use the same password now so it has become less confusing
    Jeremy recently posted..plenty of salvage cars for sale in california

  3. Kelly says

    I’m one of many people who is having a really iffy time resetting passwords if needed be. They’re a pain on the neck. So thank you for this one.

  4. Ron says

    Unfortunately I have had to do this several times due to a hacker. I like how you go into detail on how to do it and not have to hassle with it. It can be a pain if you don’t know how to reset the password, and if you had to do it as many times as I have (at least once a month) then this is an awesome post because you have made it simple and easy to follow. Thanks!
    Ron recently posted..Build List For Big Profits MRR Ebook with Master Resale Rights

    • Mitz says

      Thanks Ron I did try to make it easy.I thought I was the only one messing with the passwords or forgetting them!!! LOL :) Sounds like a few people are doing this too!

  5. Ann says

    Samuel B., you are a lifesaver for posting that link! I had exactly the same problem and used FileZilla to edit the functions.php file and get my site running again.

  6. selena says

    Nice and informative post!
    For more than a week now, I have been unable to log in to my site’s dashboard…The website works but when I log in…put in my username and password….it does not open…
    when i refresh, it goes back to the homepage, where it shows that I’m logged in, but I cannot access the dashboard…any ideas?

    • mitz says

      Hi there
      Sounds like you have a problem… First I would try to login to another user account. Also remove any plugins you might have recently installed just in case they are causing a conflict. The last resort would be to hire someone to fix this or re-install WordPress.. You need to backup your data base first so you can recreate the site.

Letsbuildwebsites.com runs on the Genesis Framework

Genesis Theme Framework for WordPress

When I changed to the Genesis Framework and the eleven40 Theme my page load score went from 58 to 79 instantly. This was without any optimization at all. The other thing about this framework and theme is that it was so simple to setup that I can highly recommend it to each and every person that visits this blog! Genesis is the smart choice for your WordPress website or blog.