I Make Blogging Easier

Start, Grow and Make Money


Reset WordPress Admin Password From phpMYAdmin

by

Before you read any further, I want to give you a heads up that there are affiliate links on this post. This means if you purchase something through one of my links, it won’t cost you anything extra. However, I may receive compensation for your purchase, this is known as affiliate marketing. Read my full disclosure here. This is one of the ways that I make money through my blog. For example, This blogger makes $50,000+ per month with her blog. Blogging can be a lucrative home-based business if done correctly.

Pin17
Tweet73
Share21
+12
113 Shares

Last updated on July 19th, 2018 at 08:45 am

Why should I be concerned with a tutorial on how to reset WordPress my admin password using my cPanel PHPAdmin? You might be surprised, one day you may wish you knew how to do this.

reset WordPress admin password

Why Would You Reset WordPress Admin Password from PHPMyAdmin?

There are several instances you may have to face this scenario. You lost your password and email that you used to install your WordPress website with. You won’t be able to reset your password via the “Lost password link.”

Related articles to help you with Your WordPress Blog:

Maybe someone broke into your website and locked you out. Don’t laugh…it can happen.

If this happens then they most likely changed the admin email from inside the dashboard, locking you out. This makes it impossible to use the reset your password from the login page, as the new email will get sent to their email.

If you are a brand new WordPress user, it can be a frightening experience. One of the first thing you should do is contact your hosting account and let them know you can’t log into your WordPress-powered site.

Most reliable hosting accounts should be able to help you get back in. It may take hours or even days to be able to log back into your site depending on your Hosting provider’s service.

So this is why I think it’s important that anyone who uses WordPress as their blogging platform at least learn the basics of resetting your password by yourself.

It’s not hard and your website will be back online in minutes.

Just follow along and I’m going to show you the easiest way I know how to get back into your WordPress dashboard. If you know of another method that is easy to use, feel free to share it. Whenever I make any changes to my website, I always like to make a backup in case I screw things up 🙂

Learn to manage your blog, skills to make money. #WordPress #freetraining at susanvelez.com Click To Tweet

Change / Reset WordPress Password from PHPMyAdmin

1. LOG INTO YOUR CPANEL

Login into your cPanel of your hosting account and scroll down until you get to PHPMyadmin. I am not sure where you will find your PHPMyAdmin icon, but in my hosting account it is down towards the bottom. So keep scrolling till you see the icon, then double click on it.

phpMyadmin cpanel2. CHOOSE YOUR DATABASE

You will see the database tables on the next screen. Find the database that you set up. If you don’t know what your database name is for your WordPress website is, then you can easily find it via your wp-config file. Take a look at this screen shot and it will show you exactly where your database name is for the site you are wanting to change the password. Once you know your database name, then choose it below by double clicking.

Related: How to Start A Blog

Find Your WordPress database

 

3. FIND WP_USERS

If you set up your database like I did when I install my websites, then make sure that it says _users at the end of the table structure. On my hosting account for my demo basic site, I only have 13 tables and I found the wp_users on the 13th row.

wp users table

4. EDIT THE WP_USERS

You should only see one user…if you’re the only one who manages your website.  Click on the edit link right beside the pencil icon.

edit WordPress users

 

You’re taken to a screen like this.

resetting WordPress password md5

5. RESETTING YOUR ADMIN PASSWORD Via MD5

Lets take the image above and break it down step by step

  1. Scroll down till you see user_pass varchar(255)
  2. Click on the drop down arrow and scroll down till you see MD5 and select it.
  3. Tab over or place your cursor in the text box beside the user_pass drop down selection. Enter your new password.
  4. I like to make it very easy to remember. You can change it once you get back inside your dashboard.
  5. Click on “Go” or similar option to save your new password in the database.

 

6. YOUR PASSWORD HAS BEEN RESET

 

one row affected

Congratulations, you have now learned how to reset your WordPress admin password from the PHPMyadmin without having to contact your hosting account.

You should now be able to log back into your WordPress website at: yourdomain.com/wp-admin

If you are still unable to log into your dashboard, run through the steps again. This method works and I’ve used it several times to reset my admin password for myself and for my clients.

blue choice optin

The Take Away…

You don’t have to be a WordPress master to learn the basics like resetting your Admin password. If you’ve ever been locked out of your WordPress blog, share your experience of how it made you feel. What did you do to get back in?

If you haven’t started blogging yet, here is my tutorial on how to start a blog on SiteGround. As a “thank you” for purchasing through my link, I’ll send you a copy of my book – The Jumpstart WordPress Guide – for free.

Hand Picked Articles for You

I have personally found this method extremely easy and quick to implement, what do you think? Let me know if this helped you get back into your WordPress website.

Recommended Blogging Resources:

 

Reader Interactions