'When I alter the password for a user then try to log out and log in with this password it doesn't work

these are the comands which I had been trying to make work: CREATE USER Nanana WITH PASSWORD '12345'; \q Then I try to login to this user with: psql -U Nanana -h localhost -p 5432 Then it asks for my password, I insert '12345' but I keep getting the error --> FATAL: password authentication failed for user "Nanana". Shouldn't it have worked????



Sources

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

Source: Stack Overflow

Solution Source