For a Cockroach connection, the user password is created and available when a sql user is created.

The password is stored in a secret. If the secret is deleted/re-creating, the password would be lost and unrecoverable. In this case, the password could be reset for the sql, so that the new password could be stored in the re-created secret.