ancient lily
Hi, I'm training to connect to my MySQL db in Cloud under SSL. The infrastructure where db is hosted can't give me the server cert. How can I set a connection under SSL? Does prisma handle it automatically?
If I use a client like workbench I can connect under SSL using the require option (without verify CA/identity obv) and in my case is enough.
I don't see in the connection option the parameter sslmode that instead is avaiable in postgresql db.
MySQL 5.7
Prisma 5.4
Ty, have a good day
elder arch
Hello 👋
Can you try using the sslaccept parameter?
You connection string would look something like this:
mysql://USER:PASSWORD@HOST:PORT/DATABASE?sslaccept=accept_invalid_certs```Hi, yes the connection works in this case. But to be honest I don't understand if this parameter guarantees SSL or not. As I understand, also no SSL connection can work. Or did I misunderstand something?
My connection should be at least SSL
elder arch
The connection will still use SSL. The sslaccept=accept_invalid_certs parameter in the connection URL tells Prisma to establish an SSL connection but to bypass the check for a valid server certificate. This means that the data transmitted between your application and the database will be encrypted, but the identity of the server won't be verified.
ancient lily
Thank you so much is what I needed 🙌