prisma can't connect to postgres database "user was denied access"
prisma can't connect to my local postgresql database even though the user I connect with is the owner of the database...
27 Replies
.env file:
proof this user can actually connect to the db:
if anyone can help quickly
I've been stuck on this for a week
Your connection string should look something like:
Can you try this format?
It looked like password field was missing in your connection string
that's because it had no password
@Nurul (Prisma) for the sake of argument, is there some command I can use to get the password for this user?
or is it just the login password for the user on the system
I mean is the users's password on postgresql the same as system login pass or different
because I didn't set a specific password for this user in postgres
You'll want to set a password for that user
how can I do that
ALTER USER user_name WITH PASSWORD 'new_password';
It's recommended to have a password, can you try setting the password with the above SQL command and pass it in the connection string and check?
Let us know in case you still get the same error.
same error 😩
@Nurul (Prisma) @Yetzederixx