Dotlayer
  • News
  • Startups
  • Tutorials
  • SEO
  • Marketing
  • Interviews
No Result
View All Result
Dotlayer
  • News
  • Startups
  • Tutorials
  • SEO
  • Marketing
  • Interviews
No Result
View All Result
Dotlayer
No Result
View All Result

How to Reset Your WordPress Password Directly in the MySQL Database When You Have With No Email Access

November 13, 2018
in Tutorials
0 0
Share on FacebookShare on Twitter

Losing your password is something that happens to the best of us. It can be very frustrating when you have to get into your own website or even after hackers have attacked your website.

It is typically easy to get around this problem if you are using a managed hosting provider such as WP Engine, Kinsta, Cloudways or all the other providers out there.

In this post, we will be going the DIY route. We are going to be looking into how to reset your WordPress password directly in the MySQL database when your email access is not working or you don’t have a Managed WordPress hosting provider to reach out to.

Before we start, we will take some time to go over how you would normally reset your password with the password reset tool for WordPress.

To start, browse to your WordPress login page, typically this is located at /wp-admin or you can just go to /admin if you have your .htaccess set up correctly, Once you are at the page such as https://domain.com/wp-admin, click on the “Lost your password?” link at the bottom.

On the next screen, enter your username or email address of your WordPress administrator account. Click on “Get New Password” and you will receive a link to create a new password via email.

The second approach which we will be talking about now is resetting your password in the database. To reset WordPress admin password is directly in the database for this step we will be using phpMyAdmin or any other MySQL database tool out there. If you don’t have access to your email or your WordPress site isn’t sending emails correctly, this might be the only solution you have.

This method is also what you would typically do if you are on a local development. If you are a Managed WordPress service customer you can always reach out to for assistance if you don’t feel comfortable doing this.

It is extremely important that you back up your database in case you have to rollback the chance, editing and manipulating tables directly from phpMyAdmin could break your site if not done correctly.

The way to reset your password via phpMyAdmin is using a SQL statement. Simply run the following from the SQL tab. Make sure to update the new_password and admin_username values with your own.

UPDATE `wp_users` SET `user_pass` = MD5( 'new_password' ) WHERE `wp_users`.`user_login` = "admin_username"

To briefly explain the SQL command that you just run, we are basically creating a new password in the database for the user. We use the MD5 function because WordPress doesn’t store passwords in plain text which make it pretty secure.

Once you have successfully reset your password, you can return to your WordPress login screen and use your updated admin credentials to access your site.

ShareTweetPin
Previous Post

How to Clear/Flush/Purge the DNS Cache from Google Chrome

Next Post

SEO 101: Search Engine Optimization and Applications

Next Post

SEO 101: Search Engine Optimization and Applications

You might also like

Calendarific Unveils New Pricing Plans

Calendarific Unveils New Pricing Plans

July 27, 2023
CurrencyBeacon vs. Currency Freaks, Fixer.io, and OpenExchangeRates: Which API is Best?

CurrencyBeacon vs. Currency Freaks, Fixer.io, and OpenExchangeRates: Which API is Best?

June 17, 2023
Mint Linux vs Ubuntu: Which is Right For You?

Mint Linux vs Ubuntu: Which is Right For You?

March 12, 2022
Net Neutrality: What is it and Why Should You Care?

Net Neutrality: What is it and Why Should You Care?

March 12, 2022
Solid State Drives – Why You Should Buy One Today

Solid State Drives – Why You Should Buy One Today

March 12, 2022

Machine Learning Algorithms Every Beginner Should Know

January 25, 2022
  • Terms of Service
  • Privacy Policy
  • Careers

© 2021 Dotlayer.com

No Result
View All Result
  • About Us
  • Advertise
  • Blog
  • Careers
  • Contact
  • Contact Us
  • Get Featured
  • Home Layout 1
  • Home Layout 2
  • Home Layout 3
  • Privacy Policy
  • Security
  • Services
  • Subscribe To Dotlayer
  • Terms of Service
  • Write For Us

© 2021 Dotlayer.com

Welcome Back!

Login to your account below

Forgotten Password?

Retrieve your password

Please enter your username or email address to reset your password.

Log In