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 spent almost a day to resolve this but no luck
Anyone please help me.
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.