There may come a time when you need to reset or modify your WordPress password. The easiest way to do so would be through Sync, but if you wanted to you could also do this via phpMyAdmin
You can reset the WordPress password for any user via the Client Dashboard in your Sync Panel. When you log in to your iThemes Sync panel, you can expand the section for the site you wish to modify the password for by selecting the down arrow icon.
When you get to the Client Dashboard, you can modify the current WordPress users or add a new one. If you are looking to reset the password, you will select the account whose password you wish to change and select the Edit option. From there you will see the following section where you can make those modifications:
You can fill in any of this information that you wish, but we're going to focus simply on the Password section where you can enter the password you wish to change it to. Then scroll down to the bottom of the page and select Save.
As an alternative, you can reset the password for a user via the WordPress database. To do that, open the phpMyAdmin tool in your cPanel and select the WordPress database from the left side of the page.
Then click the SQL tab and type the following query in the text field:
UPDATE `wp_users` SET `user_pass` = MD5('new_password') WHERE `wp_users`.`user_login` = "username";
In the above query replace new_password with the new password for the user and username with the full username of the user.
Once you've entered the query hit the Go button.