Question:
Hoping someone can help me with this issue I am running into. HeidiSQL won’t connect to my RDS database. I can connect to it when I’m on my EC2 instance but not using Heidi SQL. The error I keep getting is:
Can’t connect to MySQL server on ‘localhost’ (10061).
Anyone know how to get HeidiSQL to work with RDS on AWS?
Answer:
If I understand right, RDS just needs an SSH tunnel before connecting per HeidiSQL to its MySQL server. Setting up a SSH tunnelled connection in HeidiSQL is easy, and documented in the help section.
There are also examples on how to connect especially to Amazon RDS via HeidiSQL, for example: http://www.arcusglobal.com/news/accessing-rds-using-heidisql