SSL authentication

[sebastianswms]

Implement authentication with SSL certificates, same as tap-postgres and target-postgres.

[BamboOSZ]

Yup, I hit this same issue.
I get the following error when connecting to a particular server. Unfortunately, I do not control the server to turn it off.

sqlalchemy.exc.OperationalError: (pymysql.err.OperationalError) (3159, 'Connections using insecure transport are prohibited while --require_secure_transport=ON.') (Background on this error at: https://sqlalche.me/e/14/e3q8)

Is this on a roadmap?

[visch]

@BamboOSZ PRs are welcome, I"d assume the implementation is similar to tap-postgres. Note that you can probably use sqlalchemy_options (examples in for PlanetScale in the readme) to utilize SSL right now!

Probably just need to make this a bit more clear in the readme https://github.com/MeltanoLabs/tap-mysql?tab=readme-ov-file#planetscalevitess-support

Unless we should go deeper in our configuration support. What we have now seems ok