Are you trying to connect to an RDS instance from a Python script while maintaining SSL encryption? If so, then you are in luck, the following script provides a simple example of how to create and use such a connection.
I found myself trying to connect to a RDS instance from a Python script while maintaining SSL encryption. The official documentation was a bit vague on how to do this so I spent some time digging and eventually found how it can be done. The following scripts provides a simple example of how to create and use such a connection.
Before you can run the script you need to download the CA certificate bundle file from Amazon (Link)
import mysql.connector SSL_CA='rds-combined-ca-bundle.pem' user='<user>' password='<password>' host='<rds instance endpoint>' database='<database name>' cnx = mysql.connector.connect(user, password, host, database, ssl_ca=SSL_CA) cnx.close()
That's it, you are now connected to the RDS database and ready to do all types of great things.
Script from Technowise (with minor edits)