Connecting MySQL workbench to Amazon RDS instance

0
votes

enter image description hereWhile connecting MySQL workbench to Amazon RDS instance, am getting this error.

/** Connecting to MySQL server ... Can't connect to MySQL server on 'aa58nt64hgc91d.cuh2vqc4pep5.us-east-1.rds.amazonaws.com' (110) **/

Please help me to resolve this.

Thanks in advance

3
mysqlamazon-web-servicesamazon-rds
Copy and paste your DB security group. – Asdfg

3 Answers

3
votes

You may start checking from basics,

  1. If you are accessing the URI from public, please check the Subnet properties to confirm that they have Internet Gateway attached.
  2. Check whether security group allows access to port 3306.

Did you set it as publicly available while creating the RDS. enter image description here

0
votes

Try telnet aa58nt64hgc91d.cuh2vqc4pep5.us-east-1.rds.amazonaws.com 3306.

Verify that your security group permits port 3306 access.

0
votes

Biggest problem is the firewall. In AWS this is the Security Group -> Inbound Rules. You need to open port 3306 (listed as MYSQL/Aurora) to whatever IP address your MySQL client is running on. Unless you absolutely must (unlikely), do NOT open it up to the whole world - limit to the IPs of the server(s) that will directly access the RDS database.