How to access RDS MySQL DB

I am trying to connect to an Amazon RDS based MySQL database.

I can connect to it in an non-ssl manner (confirming ports and other config is correct), however, I cannot find a clear way of connecting to it through SSL.

I've downloaded the rds-ca-2015-root.pem root cert (and yes I know there is now a 2019 version too...one thing at a time).

What is next since HeidiSQL is asking for 4 fields?

I've searched high and low for a guide and can't find one...this seems like it would be a pretty common scenario so I'm surprised I couldn't find one.

Thanks! -Nick

You can have a look here, which basically talks about the same issue.

And you can try out the fresh nightly built installer, for which I recently updated libmariadb.dll to the current version. At least that should have solved issue #519.

Also, you can try to select one of the other libraries provided in the "Library" dropdown on the "Settings" tab. I mainly introduced that library selector for solving SSL issues, so you might have luck with it. You can even place your own ^lib(mysql|mariadb).*\.dll$ in your HeidiSQL directory, it should show up if the filename matches that regular expression, like it does for me: