Step 1. Login to Plesk Panel.
Step 2. Look for Databases option on left sidebar and click on it.
Step 3. Click on Database Users which already created by you or any other user.
Step 4. In Password field type passowrd of your own choice or you can generate default password by clicking on Generate option and click on OK to apply changes.
Congratulations!