Authentication failed against database server at `localhost` error with prisma

Authentication failed against database server at localhost, the provided database credentials for johndoe are not valid. I am getting this error while makeing queries with prisma. The db url in the env is valid as the migration did work as expected but when I am making a query, I am getting this error