• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar

I Make Blogging Easier

Start, Grow and Make Money

  • Start Here
    • About Me
    • Contact
  • Categories
    • Blogging
    • Affiliate Marketing
    • Affiliate Programs
    • Make Money
    • Blog Traffic
    • WordPress Tips
  • Shop
    • eBooks
  • Deals
    • SiteGround Coupon $3.95
    • ConvertKit Free Month
    • Tailwind Free Month
    • $5 AWIN Affiliate Network
    • More Blogging Resources
  • Blog

Reset WordPress Admin Password From phpMYAdmin

November 12, 2016 by Susan Velez

Sharing is caring!

118shares
  • Pinterest
  • Twitter
  • Facebook

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

reset WordPress admin password

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.

*This page contains affiliate links to products I recommend. If you purchase something from this page, I may receive a small percentage of the sale at no extra cost to you

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:

  • Social Warfare Plugin Why I Use It, Setup and Customization Tips
  • 7 of My Favorite WordPress Plugins and Why
  • Affiliate Marketing Tips That Will Increase The Conversions On Your Blog

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

Start Earning Money With AWIN

Join Now Button

Start Earning Money With FlexOffers

Join Now Button

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 🙂

[clickToTweet tweet=”Learn to manage your blog, skills to make money. #WordPress #freetraining at susanvelez.com ” quote=”Learn to manage your blog, skills to make money. #WordPress #freetraining at susanvelez.com ” theme=”style4"]

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

  • How to Check for Broken Links On WordPress Using A Free Plugin
  • 27 Tips for New Bloggers Make the Most of Your Blogging Journey
  • What to Expect The First Year As A New Blogger My Personal Experience

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.

My Recommended Blogging Resources!

Here are my affiliate links for my most recommended resources. I hope these resources can help you grow your blog too!

Free 12 Day Blogging Bootcamp: This is a course that will show you how to get your blog started.

ShareASale: ShareASale is one of my favorite affiliate networks. It’s free to sign up and they have tons of advertisers that make it easy for any blogger to make money through affiliate marketing.

SEMRush: This tool is amazing and has helped me increase my organic traffic. It is expensive, so don’t pay for it every month. When I’m NOT using it, I’m using KWFinder to help me with my keyword research.

Quiz: Which theme is best for your blog?: Take this quiz if you’re having a hard time trying to decide which WordPress theme you should use.

If you want to build an email list and send newsletters, I recommend ConvertKit: I’ve started using this to help me grow my blog and it is so user-friendly.

JumpStart Blog Traffic: Learn my secrets to growing my blog from zero pageviews to growing each and every month, using Google and Pinterest.

Filed Under: WordPress Tips Tagged With: how to reset my WordPress admin, reset WordPress admin password, reset WordPress admin password using PHPMyadmin, reset WordPress password

About Susan Velez

Hi! I'm Susan welcome to my blog. Are you ready to use the Internet and a computer to change your finances? I share tips to help you make money online through blogging, side hustles and other non-traditional methods learn more Twitter, Facebook, Pinterest and YouTube

Reader Interactions

Primary Sidebar

SUPPORT THIS SITE

I work hard to bring you the best content to help you start, grow your own blog so you can change your life. Support this blog, so I can continue to bring you the best content.

Follow Me On

Twitter 1.3KFollowers
follow
Youtube 251Subscribers
subscribe
Pinterest 10.8KSubscribers
subscribe
RSS 19Subscribers
Subscribe

Hi! I'm Susan welcome to my blog. Are you ready to use the Internet and a computer to change your finances? I share tips to help you make money online through blogging, side hustles and other non-traditional methods learn more Twitter, Facebook, Pinterest and YouTube

What Are You Looking For?

COPYRIGHT

I love it when you share! Please keep in mind that all images and text on this site are property of Susan Velez. Feel free to use one or two photos provided that a link back to my original post. Please do not remove any watermarks, crop, or edit any of my images without first obtaining written permission from me. Pinning is always welcome and appreciated! Thank you!

Copyright © 2019 · Susan Velez · Powered by WordPress and the Genesis Framework | Affiliate Disclosure | Privacy Policy


Susan Velez website is a participant in the Amazon Services LLC Associates Program, an affiliate advertising program designed a means for sites to earn advertising fees by advertising and linking to Amazon.com

Copyright © 2019 · Wellness Pro on Genesis Framework · WordPress · Log in

X
Share this
Subject:
Message:
Ajax loader