Passwords are only shown once (when they are generated). Afterwards, only the username associated to the password can be viewed.
Connecting to a deployment requires a username and password. Credentials can be viewed from the User select in the Connection details of the main page:
or the SQL workspace from the Database users panel on the sidebar.