Connecting to Amazon RDS

Discussion of open issues, suggestions and bugs regarding database management and administration tools for MySQL
Post Reply
mommaroodles
Posts: 7
Joined: Tue 09 Sep 2014 14:15

Connecting to Amazon RDS

Post by mommaroodles » Fri 16 Jan 2015 17:25

Hi

I wonder if anyone can please help me.

I created an instance and installed WordPress using ElasticBeanstalk at Amazon so far everything is working perfectly. I now naturally need to have access to the database and I know that the connection strings I'm using are correct and that it must have something to do with the security groups.

In my RDS Console when I click on Security Groups - I get the following message:
Your account does not support the EC2-Classic Platform in this region. DB Security Groups are only needed when the EC2-Classic Platform is supported. Instead, use VPC Security Groups to control access to your DB Instances. Go to the EC2 Console, Go to the EC2 Console to view and manage your VPC Security Groups. For more information, see AWS Documentation on Supported Platforms and Using RDS in VPC.
So I go to EC2 Console and edit the security groups nothing I do there is working and I am really hoping someone can point me in the right direction.

I am truly now at my wits end.

Many Thanks
Melanie

alexa

Re: Connecting to Amazon RDS

Post by alexa » Mon 26 Jan 2015 15:22

Could you please provide us the following information:

1. Screenshot of the form Details of the DB Instance.
2. Screenshot of EC2 security groups.

Generally, you have to add Inbound rule into security group associating with RDS instance.

Here is an example of the rule granting an access to MySQL for all:

Type Protocol Port Range Source
MYSQL TCP 3306 0.0.0.0/0

The Host to connect to the database = Endpoint of the DB Instance

Post Reply