Is it possible to receive Plesk user password from database?
All passwords are stored in the encrypted format in Plesk database.
Plesk 11.x and higher does not provide any possibility (including API) to retrieve customer's passwords from the database as plain text. This is by design.
In order to reset the password for Plesk user account, use the "Forgot your password" link on a login screen.