how to change wordpress password from phpmyadmin

Sharing is caring!

Do you want to change your WordPress password from database or PHPMyAdmin? In this article, I will explain to you that how can you reset or change your WordPress password from the database.

Step 1: Login to your Cpanel and you will need to click on PHPMyAdmin. you can see PHPMyAdmin under DATABASES section.

change wordpress password from phpmyadmin

  • Bluehost

  • Step 2: It will take you to PHPMyAdmin from where you need to select your database.

    change wordpress password from database

    Step 3: After selecting your database, you need to select wp_users table.

    how to change wordpress password from phpmyadmin

    Step 4: Once you will click on the wp_users table it will show you the list of users. You need to select the user for which you want to change the password. Click on Edit to select the user for which you want to change the password.

    how to change wordpress password from database

    Step 5: After clicking edit link it will open a form. Here you need to change your wordpress password.

    wordpress password change from phpmyadmin

    You need to remove the value of user_pass field and replace it with your new password. You can see I have written newpassword but you can choose any password and after this, you need to select MD5 from the dropdown under Function column. MD5 is used to encrypt password using MD5 hash. After entering you password click on Go button.

    Congratulations, your password is changed. Now you can log in using your new password.

    Sharing is caring!

    Rishab Kapoor on FacebookRishab Kapoor on LinkedinRishab Kapoor on TwitterRishab Kapoor on Youtube
    Rishab Kapoor
    A Blog writer, a Web developer and a passionate teacher. Teaching on YouTube from last 7 years. Like to write articles about Web designing, Web development, Digital Marketing, and Online money making techniques. If you have any question about Web technologies and your career then you can contact me via above my social media profiles.