message: "\nInvalid `prisma.user.findUnique()` invocation:\n\n\nError querying the database: Server error: `ERROR 08S01 (1043): Bad handshake'

Henson Dedoro 0 Reputation points
2023-02-22T08:13:44.9933333+00:00

i have a working container application running on prisma client and connected to mysqlflexible server got an error connection.

"message: "\nInvalid prisma.user.findUnique() invocation:\n\n\nError querying the database: Server error: `ERROR 08S01 (1043): Bad handshake'"

Guys, do you have an insigth on this issue on mysql on azure?

Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
757 questions
Azure Container Apps
Azure Container Apps
An Azure service that provides a general-purpose, serverless container platform.
325 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. MayankBargali-MSFT 69,946 Reputation points
    2023-02-27T05:36:58.3066667+00:00

    @Henson Dedoro Thanks for reaching out. Can you please confirm if you are running your application in azure container instance or azure container apps. As per the error it looks like the connectivity issue between your application and database. Can you please confirm if you are Azure MYSQL version and the driver connector version (ODBC client etc.) is same as this could be one of the reason the handshake is getting failed.