Next.js Discord

Discord Forum

Error querying the database: Unknown authentication plugin `sha256_password'.

Unanswered
Cornish Rex posted this in #help-forum
Open in Discord
Cornish RexOP
Hello,

i know this is'nt the right place but i'm facing an issue with Prisma, when trying to push my Prisma schema to a MySQL database, I encountered the error message:
Error: Schema engine error:
Error querying the database: Unknown authentication plugin `sha256_password'.

My MySQL server is using sha256_password, but Prisma seems to be incompatible with it. I cannot change it since the MySql Server is hosted on "cPanel" which i don't have access to the mysql configuration.

Is there a way to configure Prisma to use a different authentication plugin within the Prisma schema itself?

Using latest prisma version (v5.5.2)

3 Replies

I dont think there is a way currently to solve this issue.
I think that sha256 is deprecated aswell.
@Clown I dont think there is a way currently to solve this issue.
Cornish RexOP
the weird thing is that it worked yesterday lol, might be from a mysql update