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.
Step 2: It will take you to PHPMyAdmin from where you need to select your database.
Step 3: After selecting your database, you need to select wp_users table.
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.
Step 5: After clicking edit link it will open a form. Here you need to change your wordpress password.
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.