MySQL Connector with SSL

KNIME Analytics Platform
1

Hi,

I'm trying to connect to an RDS on AWS using the MySQL Connector node.  I'm getting an "access denied" error because of SSL encryption.

Is there a way to point the MySQL Connector to the Certificate Authority (.pem) file on my local machine to gain access?

I'm able to use MySQL Connector node to connect to a separate RDS on AWS that does not have the SSL enabled.

Thank you.

2

You can try to use the generic Database Connector node and come up with your custom connection URL. I'm not sure if you can specify a custom certificate this way, though.