error while trying to connect to planetscale server

[Nithur-M]

I am trying to connect to MySQL server managed by planetscale and running into an SSL issue.
server does not allow insecure connections, client must use SSL/TLS
Please help me resolve it. Thanks.

[sidorares]

you need to set ssl: {"rejectUnauthorized":true} in connection options ( or use a connection string the way planetscale suggests for node.js example when you generate a password )

[Nithur-M]

Thank you @sidorares, that's what I went with. But I am wondering if there will be any downsides. Thank you.

[sidorares]

You mean downsides of having ssl encryption? With planetscale you have no choice, but if you connect to your server in your own vpc it might be better to avoid ssl for perf reasons, it adds few roundtrips to a connection time

[Nithur-M]

Thanks @sidorares, May I know what ssl: {"rejectUnauthorized":true} is exactly doing?

[sidorares]

its passed down to tls client, see docs at https://nodejs.org/dist/latest-v18.x/docs/api/tls.html#tlsconnectoptions-callback.