Steps To Connect
For example: When you add an Internet gateway, you can add only the required CIDR range to the routing table for the destination, see Example routing options and use for another IP to create EC2 Instance and allow all privileges conditions or also allow to PORTS.
configuration is for an RDS MYSQL Database Management System instance that is in a Virtual Private Cloud System and has security groups set up for the EC-2 instances.
configure and Launch Amazon EC-2 instance
Open Amazon EC2 Console, and select Launch Instance.
Select an (AMI) Amazon Machine Image
Choose instance type, select Next: click Configure Instance Details.
For Network, select the [Amazon Virtual Private Cloud] VPC that the RDS DB instance uses.
This configuration for the security group allows traffic from the private IP address of the EC2 instance. If the EC2 instance and the RDS DB instance use the same VPC, you do not need to modify the route tables used by the RDS DB instance. If the VPC is different, create a VPC peering connection to allow connections between those VPCs.
Connect to RDS DB Instance from your local machine
The steps to connect to an RDS DB instance differ depending on the client you use.
Example: uses the Workbench(MYSQL) client to connect to the host:
Start a new connection, and choose Standard TCP/IP over SSH for the connection method.
MySQL instance settings Details:
We are an ERP development company that offers complete enterprise software solutions for diverse business applications and use-cases. Our development team specializes in using the latest tech stack and next-gen to build scalable business solutions. To learn more about our custom ERP development services, contact us at [email protected].