How to Reset Admin Password for WordPress in PhpMyAdmin

Resetting your password in WordPress via PhpMyAdmin is a simple process that can help you regain access to your site.

Once you’ve set the new password, make sure you keep it safe and secure. But if you forget it, it’s no big deal.

The next time you run into a forgotten password issue, you will know exactly how to reset your password in WordPress using PhpMyAdmin.

Reset WordPress admin panel password

1. When you cannot remember your password, we need to click on the Lost Your Password link at the bottom of the page.
2. By clicking on this link and at the address that appears, we enter the e-mail address we use in the Admin panel and click the Get New Password button.
3. When you click this button, an e-mail will come to your e-mail address and we will be able to reset our password to the admin panel via that mail.

However, since the mail() function is blocked on some servers, you cannot send a link to your e-mail address, your server blocks it. You encounter such an error.

The email could not be sent. 
Your site may not be correctly configured to send emails. Get support for resetting your password.

If you don’t have access to this email address or your WordPress site cannot send an email, you will need to reset your password directly from the database.

Change admin password on PhpMyAdmin

The easiest way to do this is to use PhpMyAdmin. You can access it from the cPanel of the hosting company where we host your website, or you can access it directly from the address if you know the address.

1. I click on the database name and you will see the tables. The table we will use here to log in to the admin panel is the wp-users table.

2. Let’s click on the Browse link on the right side of wp-users. The field we will be interested in here is the user_pass field. Because we forgot our password and we need this password to enter the admin panel.
3. Whichever user’s password you forgot, click on the Edit link next to that user.
4. I select the value in user_pass and delete it. We will write a new password here.

5. After setting the password, I click on the drop-down box right next to it. And there I find MD5 among the options.
6. After doing these two operations, I scroll down the page. I save these changes by clicking the Go button. Changes saved.

After doing this, your password will be changed. Now enter the admin panel login page and type your username and new password. You will reach the admin panel.

If you entered a temporary password, remember to enter a stronger password on the Your Profile page.