Resetting a WordPress user password from phpMyAdmin in Plesk is essential when you are locked out of the WordPress admin panel and cannot reset the password via email.
To reset a WordPress user’s password, follow the steps:
- Log in to the Plesk Panel.
- Select the Websites & Domains section.
- Choose the Database as shown below and click on phpMyAdmin.
- Select the Users table from the left side of the screen.
- You will find a list of users. Select the user whose password you wish to reset.
- Click on Edit.
- Select MD5 using the drop-down menu.
Note: WordPress does not save passwords in plain text, which is why the MD5 function is selected in phpMyAdmin. When you enter a plain-text password and save it using MD5, phpMyAdmin converts it into a hashed format that WordPress can read and authenticate. - Type the new password into the provided field.
This way, you can reset WordPress user password from phpMyAdmin in plesk.
If you’re using cPanel, learn How to reset the admin account password with softaculous in cPanel