IAM Role-Based RDS Access

Hey,

Hope you're keeping well.

To connect to an RDS MySQL instance using IAM authentication in Python, first ensure your DB instance has IAM DB authentication enabled and your IAM role or user has the rds-db:connect permission for that DB resource ARN. In your Python code, use boto3 to call generate_db_auth_token with the endpoint, port, username, and AWS region to get a temporary auth token. Pass this token as the password when creating the MySQL connection with a library like PyMySQL or mysqlclient. Make sure the client connects over TLS, as IAM auth requires SSL.

Thanks and regards,
Taz