How to setup a secure connection with AWS MySQL (RDS)

[_hans1]

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:

• 'SSL Key' (c:\path_to\client-key.pem)
• 'SSL Certificate' (c:\path_to\client-cert.pem)
• 'SSL Certificate Authority' (c:\path_to\ca-cert.pem)

Has anyone experience with this / done it? Any suggestions how to do it?

Thanks for any help!

Cheers,

Hans

[danielbrun2 · Accepted solution]

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

[_hans1]

Hi Daniel, thanks, this works indeed! (took me some time to find the time to test it ;-).

Cheers,

Hans 

[pkkrish22]

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

[danielbrun2]

Hi,

I am not sure the ODBC driver for MySQL support what you are trying to do - is this a RDS instance on AWS?

When you connect via SSH you basically connect to the server running the MySQL DB and then do a connection to localhost.

Best,

Daniel

[pkkrish22]

i did not get what to you told, Can you please elaborate. i need to connect to AWS RDS MYSQL DB instance from Alteryx, let me know how to do that

[danielbrun2]

Hi,

Okay - I do not understand why you wan't to create the connection over SSH. When you create a RDS instance of MySQL you get a username and password.

Best,

Daniel

[pkkrish22]

yes i have the db instance name and username and password for that DB instance. but how to connect to Alteryx with those ? we need to create a connection first rite between the AWS and Alteryx

[danielbrun2]

Hi,

Please try with the configuration in this thread that is marked as a solution.

If that does not work please provide a screenshot of the configuration as well as the error message.

Daniel

[mgonjari]

Where will I get MySQL ODBC connecter  in latest version.

I am trying to connect Mysql on AWS to alteryx.