1. Home
  2. WordPress Tutorials
  3. How to Manually Reset Your WordPress Admin Password

How to Manually Reset Your WordPress Admin Password

Losing that admin password for WordPress is often troublesome. Whether you forgot what it was or someone hacked the account and changed it, you need access. Usually, you can reset this by using the “forgot password” link on the login screen. But what if the email address for the admin account is also changed? That’s when a manual reset is probably a better idea.

Today, I’m going to show you how to reset your admin password using phpMyAdmin from cPanel. You’ll be accessing the site’s database, but don’t worry. As long as you don’t change the wrong things, the site will be fine.

Accessing phpMyAdmin

phpMyAdmin is a database tool in cPanel. It gives you access to any database that is on your web host giving you absolute control of the information.

From cPanel, scroll down and click on the icon for, “phpMyAdmin.” It will be under the section for “Databases.”

phpMyAdmin

Click the database of the website in the left column. If you’re not sure which database to use, take a look at the wp-config.php file of your website.

Click Database

You may have just the single database if all you have is the one website. Since I have several on my account, the list continues to grow. This is why it’s important you’re editing the admin password for the correct website.

Click the “wp_users” table from the main window.

WP Users

Click the “Edit” link under the Options column for the admin account. As you can see, I only have one account connected to this website. If there were more users, you need to make sure you’re editing the correct one. Always check under the “user_nickname” or “user-email” columns to verify you’re editing the admin account.

Edit Admin

Select “MD5” in the Function column using the drop down window in the use_pass row.

Choose MD5

Input a new password in the text box to the right of MD5.

New Password

Once your password is changed, click “Go” at the bottom.

Click Go

Your password is now changed and you’ll be able to login.

Keep Your Site Secure

Website security is of utmost importance. Regardless if you simply lost your password or the account was hacked, you should always monitor the safety of your data. While it may be easy to undo some of the damage from a hacker gaining access to a site, you may face a lot of problems afterwards.

What’s your favorite security plugins to use with WordPress? How often have you forgotten a difficult password?

Author: Josh Dargie

My name is Josh Dargie and I’m the Operations Manager at GreenGeeks. I’ve been with the company since 2009. I have over 16 years of experience working with and for various web hosting providers specifically in development, day-to-day operations and customer service.

Updated on September 22, 2017

Was this article helpful?

Related Articles

Comments

  1. Hey Josh,Its most simple and working WP password reset formula.Thank you so much

Add A Comment