Hi,
This might have been asked before. I am wondering if there is a way Ansible can create db schema/users, using the “mysql_<db|user>” in my instance, on a RDS instance that is not publicly accessible?
I have been able to successfully create the appropriate db security group and RDS instance using Ansible. I can also remotely connect (SSH) to the RDS instance using MySQL Workbench using an EC2 instance to access the private network within the VPC that allows access to the RDS. Ie. is there a way Ansible can connect to the RDS via the EC2 instance, similar to what MySQL Workbench does (using SSH)?
Any help or pointers are much appreciated, cheerio,
Luuk