RDS Instance: Allow Public Access

Enabling Public Access to an RDS Instance

How to Allow Public Access to an RDS Instance

Tasks

1. Verify Existing RDS Instance: Confirm that the RDS instance devops-rds is already created.

2. Configure Public Access: Set the RDS instance devops-rds to be publicly accessible.

3. Check Default Port: Ensure the RDS instance is accessible on the default port 3306.

Steps

1. Navigate to the RDS service and search for instance.

   
2. RDS → Databases → devops-rds → Modify

3. 

   Connectivity → Publicly Accessible

4. 

   Click Continue.

5. 

   Select Apply immediately

6. 

   Edit the inbound rules to allow traffic on port 3306 by opening it to 0.0.0.0/0.

7. 

   To get username

aws rds describe-db-instances --db-instance-identifier devops-rds --query "DBInstances[0].MasterUsername"

1. Now let’s connect with endpoints.

2. 

   Let’s try to connect the mysql from outside with the username, endpoints and password which we already created on devops-rds.

3. 

   Boom!! We are able to access the mysql from our localhost too.

#cloud #aws #cloudcomputing #rds #mysql #happlearning