Prisma P1000: Authentication failed against database server at {database_host}, the provided database credentials for {database_user} are not valid

What it means in plain English

Prisma's error reference defines P1000 as: Authentication failed against database server at {database_host}, the provided database credentials for {database_user} are not valid. Please make sure to provide valid database credentials for the database server at {database_host}.

P1001 is a different code. That one says the database server cannot be reached. See Prisma P1001: Can't reach database server.

Likely causes

• The user or password in the URL Prisma opened does not match the database at the host in the P1000 line.
• The deployed app still has the previous password. See Changed an environment variable on Vercel but the live site still uses the old value.
• The host itself is wrong. That shows up as P1001, which names the host and port it could not reach.

How to fix it, step by step

1. Read {database_host} and {database_user} in the P1000 message. Those are the server and the user Prisma tried.
2. Put a connection string whose user and password are valid for that server into the environment variable the app reads.
3. Redeploy so the running function picks up the new value.
4. If the next error is P1001, the credentials line is no longer the failure. Fix the host and port on that page.
5. If the next error is prepared statement "s0" already exists, the database accepted the login and the pooler mode is the next step. See Prisma: prepared statement "s0" already exists.

How to check it worked

• The function log no longer prints P1000.
• The first query runs against the host named in the old error.

Sources

• https://www.prisma.io/docs/orm/v7/reference/error-reference (opens in a new tab)