Amazon RDS: Your connection attempt failed for user 'master' to the MySQL server

0
votes

I am unable to connect to the MySQL Amazon RDS instance I created.

I am following the AWS RDS tutorial to connect and entered:

  • The endpoint in the "Host" on the workbench
  • Credentials including the username and the password
  • Port is set to 3306

I get the error:

Cannot Connect to Database Server

Your connection attempt failed for user 'master' to the MySQL server at xxxx.rds.amazonaws.com:3306:

Can't connect to MySQL server on 'xxxx.amazonaws.com' (10060)

MySQL Workbench error Here is the link to the tutorial i am following Tutorial on setting up & connecting to Amazon RDS

1
mysqlamazon-web-servicesmysql-workbenchamazon-rds
PS- I also tried posting my question on the AWS help forum but was unable to do so. Apparently, they make you wait several hours in order to post. :( – Linkx_lair
Can you provide a link to the tutorial you used? – John Rotenstein
thanks for cleaning up my question @John – Linkx_lair
Since the tutorial doesn't exactly specify how to configure the Security Group, I'd say that's the first thing you should check. – John Rotenstein
Looks like your instance is accessible. But the port is blocked by the subnet group. It is not a good idea to post the DB hostnames to the public. – Rajan Panneer Selvam

1 Answers

2
votes

Things to check:

  • Since you are connecting from the Internet, the Amazon RDS database must be launched in a public subnet
  • When launching the Amazon RDS database, select "Publicly available"
  • Assign a Security Group that permits Inbound traffic on port 3306 from your IP address (or 0.0.0.0/0, but that is much less secure)