I would like to setup a secure connection with a MySQL database hosted in RDS from Amazon Web Services.
AWS provides only one PEM file (see: http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/CHAP_MySQL.html#MySQL.Concepts.SSLSupport) but the MySQL ODBC connecter in Alteryx provides 6 input options and the one PEM file provided by AWS does not work with it.
I did found on stackoverflow (http://stackoverflow.com/questions/5880503/mysql-connection-using-odbc-5-1-with-ssl) the followoing remark:
Only fill out the fields:
Has anyone experience with this / done it? Any suggestions how to do it?
Thanks for any help!
Cheers,
Hans
Hi Hans,
I have tested on our own environment and the following works in regards to connecting - remember the "Verify SSL certificate" checkbox. Please let me know if it works for you.
Best regards,
Daniel
Hi Daniel, thanks, this works indeed! (took me some time to find the time to test it ;-).
Hi Daniel,
i tried your approach but it was not working. i have only RSA private key to connect to the server. please let me known what to do and also let me know how to get SSL certificate Authority file. but i can connect from MYSQL Work bench using Standard TCP/IP over SSH connection method. i did not see that type of method in Mysql ODBC connector. how to get that, please help
