PrismaClientInitializationError

[sheri0441]

Question

Why I am getting this error, PrismaClientInitializationError?

I am currently learning Nextjs. During the course, I need to connect MySQL with NextJs through Prisma. I have followed all the steps one by one. But whenever I try to call the api I get this error.

` PrismaClientInitializationError: 
Invalid prisma.user.findMany() invocation:


Authentication failed against database server at `127.0.0.1`, the provided database credentials for `root` are not valid.

Please make sure to provide valid database credentials for the database server at `127.0.0.1`.       
    at si.handleRequestError (D:\Practice Folder\Full Stack\nextjs\next-app\node_modules\@prisma\client\runtime\library.js:125:7117)
    at si.handleAndLogRequestError (D:\Practice Folder\Full Stack\nextjs\next-app\node_modules\@prisma\client\runtime\library.js:125:6151)
    at si.request (D:\Practice Folder\Full Stack\nextjs\next-app\node_modules\@prisma\client\runtime\library.js:125:5859)
    at async l (D:\Practice Folder\Full Stack\nextjs\next-app\node_modules\@prisma\client\runtime\library.js:130:9805)
    at async GET (webpack-internal:///(rsc)/./app/api/user/route.tsx:16:19)
    at async D:\Practice Folder\Full Stack\nextjs\next-app\node_modules\next\dist\compiled\next-server\app-route.runtime.dev.js:6:63251 {
  clientVersion: '5.8.1',
  errorCode: undefined
}`

Even though Prisma Studio is working just fine,

Link to repository

How to reproduce (optional)

Expected behavior (optional)

No response

Information about Prisma Schema, Client Queries and Environment (optional)

// Add your schema.prisma

// Add any relevant Prisma Client queries here

• OS:

• Database:

• Node.js version:

• Run prisma -v to see your Prisma version and paste it

[ludralph]

Hi @sheri0441 👋

Thank you for raising this question.

According to the error message, Prisma Client is unable to establish a connection to your database because the username, password, or other connection details are incorrect. Can you double-check your .env file or wherever you are storing your database credentials to ensure that the username (root in your case) and password are correct. If you've recently changed your database password or other connection details, you may need to regenerate the Prisma client by running npx prisma generate.

It might also interest you to know that if you use $ symbol as part of your password in your .env file, you will need to escape it with \. i.e \$. See this section of Next.js documentation.

If this answers your question, it would be great if you could mark this Discussion as answered to indicate that it has been resolved.

Otherwise please let us know how else we can help you further or close the Discussion if it was resolved in some other way 🙏

[sheri0441]

Thanks for your advice and its works.

[nikolasburk]

Hey @sheri0441 👋

During the course, I need to connect MySQL with NextJs through Prisma

Out of curiosity, which course are you following to learn about Next.js and Prisma?

[sheri0441]

I am following the Next.js course by Mosh Hamdani.

[iamzainn]

i have same issue but i uses supabase as a backent npx migrate is working and my schema stored in database at supabase but prisma client error is comming
i uses this code :
import { PrismaClient } from "@prisma/client";

const prismaClientSingleton = () => {
return new PrismaClient();
};

declare global {
var prismaGlobal: undefined | ReturnType;
}

const prisma = globalThis.prismaGlobal ?? prismaClientSingleton();

export default prisma;

if (process.env.NODE_ENV !== "production") globalThis.prismaGlobal = prisma;