I've read this documentation and several other sources but to no avail: I cannot connect to my MySQL instance from MySQL Workbench.
I can connect to my RDS instance through EC2, but I cannot dump from it because it is outdated:
mysqldump Ver 10.13 Distrib 5.1.71, for redhat-linux-gnu (x86_64)
And I receive this message:
mysqldump: Couldn't execute 'SET OPTION SQL_QUOTE_SHOW_CREATE=1': You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'OPTION SQL_QUOTE_SHOW_CREATE=1' at line 1 (1064)
My EC2 is running
Red Hat Enterprise Linux Server release 6.5 (Santiago), so I cannot use the fix that is out there for the above issue.
So I want to connect to my RDS from Workbench. The mysql.exe that comes with MySQL Workbench:
mysql.exe Ver 14.14 Distrib 5.6.13, for Win32 (x86)
Which matches the version I am using for RDS, which is
mysql(5.6.13). Sadly, MySQL Workbench gives me the following:
Cannot Connect to Database Server Your connection attempt failed for user '' from your host to server at ...: Can't connect to MySQL server on '' (10060).
So the good news is that I am now able to connect to my RDS using my EC2 instance as an SSH pipe. I can post this in an answer and accept it if my question is reopened.
Bad news is that I might still need to publicly access my RDS sometime in the future. I found this blog post, but it seems to be outdated and did not help. Maybe I'm just not seeing it.