I am trying to connect with Mysql DB instance (inside RDS) using IAM permissions from EMR(pyspark)
for test purpose i have provided policy 'AmazonRDSFullAccess' to my EMR role, and trying below python code
pymysql.connect(host=host, user=user, passwd='mypswd', ssl=ssl)
and i am getting error as
pymysql.err.OperationalError: (2003, "Can't connect to MySQL server on '-.eu-central-1.rds.amazonaws.com' (timed out)")
The above code is working fine if i add my EMR cluster IP address in inbound rule of the security group attached in the db instance.
But my requirement is to connect with the db instance with just by using IAM since my IP address is dynamic(each time I create new EMR cluster), so each time i cannot add a new IP in security group and i do not want to allow all ip(0.0.0.0) in inbound rule,