prisma: Error 28000(9002): SSL Connection is required even when database does not require

ref)https://docs.microsoft.com/azure/mysql/concepts-ssl-connection-security

In some cases, applications require a local certificate file generated from a trusted Certificate Authority (CA) certificate file to connect securely. Currently customers can only use the predefined certificate to connect to an Azure Database for MySQL server which is located at https://www.digicert.com/CACerts/BaltimoreCyberTrustRoot.crt.pem.

1. download https://www.digicert.com/CACerts/BaltimoreCyberTrustRoot.crt.pem🔐 and save at /prisma

2. /prisma/prisma.schema

   generator client {
     provider = "prisma-client-js"
   }
   
   datasource db {
     provider = "mysql"
     url      = env("DATABASE_URL")
   }
   

3. update /prisma/.env

   DATABASE_URL="mysql://test@test-mysql:mypassword@test.mysql.database.azure.com:3306/testdb?sslmode=require&sslcert=BaltimoreCyberTrustRoot.crt.pem"
   

4. npx prisma introspect

   Prisma schema loaded from prisma\schema.prisma
   
   Introspecting based on datasource defined in prisma\schema.prisma …
   
   ✔ Introspected 1 model and wrote it into prisma\schema.prisma in 638ms
   
   Run prisma generate to generate Prisma Client.
   

5. npx prisma generate

6. 🙆‍♀️🙆‍♂️🙆‍♀️🙆‍♂️🙆‍♀️🙆‍♂️

I faced the same issue and the cert unfortunately didn’t work for me 🤷 Instead I used ?sslaccept=accept_invalid_certs and worked without the cert

@handelcamilo The error is coming the database driver. Can you please make sure that you can connect to your database without ssl from a database GUI or from another driver.