I have the above stack running successfully but now want to make an external ODBC connection to one of the databases. I've opened port 3306 in the relevant EC2 security group (and outbound on my client PC), options bind-address and skip-networking do not appear in my.cnf so the default of 0.0.0.0 (all addresses) should apply. When I try to "Test" with MySQL Connector/ODBC I get "Connection failed. Can't connect to MySQL server on ip address"
When I try a direct "telnet [ip address] 3306" I get a similar "Could not open a connection to the host, on port 3306: Connect failed"
Even if my GRANT is incorrect, shouldn't MySQL respond to the telnet? Any ideas what I'm missing?