'Heroku postgres connection failed because of password auth

I want to connect to the heroku postgres database I have set up using spring boot java. But before that I wanted to try and connect using pgAdmin 4. When I tried this I got an error saying the authentication for the 'username' had failed. Then I started adding the database to my application.proporties file in spring boot to test it there. I got the samen error message. This is the error message I got in spring boot: org.postgresql.util.PSQLException: FATAL: password authentication failed for user "username". I then even tried it in DBeaver. But still the same error.

heroku postgres credentials

application.properties in spring boot java

I checked multiple times if the password and username are the same. I really don't know what to do now, because I can't find any documantation on the heroku website



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source