Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.

How to access RDS MySQL DB

nstech's profile image nstech posted 6 months ago in General Permalink

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

1 attachment(s):
  • 2020-02-04_16-42-26
ansgar's profile image ansgar posted 6 months ago Permalink

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:

Description

Please login to leave a reply, or register at first.




Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.