Home » Tutorials » Wordpress » How to reset WordPress password from PhpMyAdmin

How to reset WordPress password from PhpMyAdmin

lost wordpress password

Nowadays, it might be very common to forget the password for your own blog. When trying to protect ourselves from hackers, we are thinking too complicated passwords that are not easy to remember. Or the even more difficult option – we auto generate random passwords that are impossible to remember. Your blog password might also be hacked or something else. In all of these cases, that might be very unpleasant moment.

When we are using WordPress on our hosting, we still have chance to restore it by clicking the “Lost your password?” link. Then we just have to type our username or email address. But what happens if we are working in localhost. In a localhost environment, configurations may vary from machine to machine. Most of the time “Lost your password” will not work as email system is either not supported or not properly setup.

So the problem is that you forgot or don’t know your blog password and the “Lost your password?” button is not working properly.

The solution

Go to PhpMyAdmin. If you work in localhost, the url should be http://localhost/phpmyadmin. If you use average hosting, find the phpMyAdmin button in your cPanel.

find phpMyadmin

Then look for your database name at the left side. If you don’t know your DB name, you can check it when you open the wp-config.php file from your WordPress configuration.

After you find your database, click on wp_users.

reset wordpress password

Click on the Edit button, look for the user_pass column and then choose MD5 for the function dropdown.

MD5 password in phpmyadmin

Then type your new password in the value field (the field with the strange characters). Pay attention that the value field is case sensitive.

Finally click the “GO” button at the bottom right. That’s it. You have successfully changed your password.

If something goes wrong, you can try a second way. Simply generate a MD5 password with the Javascript MD5 generator. If you use that way, you don’t have to change the Function dropdown to MD5. Simply paste your new password in the value field.

Your new password should look in that way – cd1e737a4d9836af779a1b6f414d0f54.

Nowadays, it might be very common to forget the password for your own blog. When trying to protect ourselves from hackers, we are thinking too complicated passwords that are not easy to remember. Or the even more difficult option – we auto generate random passwords that are impossible to remember.…

Review Overview

0%

User Rating: 3.77 ( 6 votes)
0

About Georgi Dyulgerov

Georgi Dyulgerov

Founder of fTutorials.com - the website aiming to keep you in touch with the latest technologies in the brand. Also a Freelance web developer.

Check Also

wordpress website speed

How to Speed Up your WordPress Site

Site speed is one of the most important characteristics for any product website, blog, online ...

Leave a Reply

Your email address will not be published. Required fields are marked *


Loading Facebook Comments ...