Unable to connect from MySQL Workbench to AWS RDS instance

Question

I have created a MySQL instance in AWS and trying to connect with it from MySQL workbench from my local system.

I made the MySQL instance publically accessible, added a security group and set inbound rules to allow traffic. as shown below

But when I am trying to connect from MySQL workbench

I get error as shown here

I spent almost a day to resolve this but no luck

Anyone please help me.

Here is the route tables

subnets:

route table :

Answer 1

Looks like the database is launched in a private subnet. If the need to publicly access the data, it need to be in a public subnet. A subnet can be made public by attaching Internet Gateway to the route table associated with the subnet.

Please follow the steps below to attached Internet Gateway to the Route table.

1. Open the Route Table
2. Click on Edit Routes
3. Click on Add route
4. Select Destination as 0.0.0.0/0
5. Select Target as Internet Gateway
6. Save Changes