Unable to connect to RDS MySQL database from MySQL Workbench

1
votes

I have created a RDS MYSQL database and have set public access , modified VPC security groups enter link description here

but I am still not able to connect to the MYSql. Telnet also fails Could not open connection to the host, on port 3306: Connect failed

Connection from mysql workbench gives the following error Can't connect to MySQL server at .... (10061)

I've checked various posts in stack exchange on this error . But still unable to figure out what is missing.

Kindly let me know what is missing.

1
mysqlamazon-web-servicesmysql-workbenchamazon-rds
I am not sure. But it is highly doubtful that RDS will allow connections through TCP. Normally RDS on AWS will run on Secure Sockets Layer (SSL) connections with DB instances running the MySQL database engine only. So, your inbound security changes in opening a port shall not help – Anirudh
@RTM I am having the same problem right now. Can you describe how were you trying to connect? – Fernando Santiago

1 Answers

0
votes

Some things to check:

  • The RDS instance should be configured as publicly accessible
  • The RDS instance should be launched in a public subnet
  • The Security Group should permit Inbound access for your IP address for port 3306
  • Your network must not be blocking the connection (try from another network, such as work/home or tethered via your phone)