I set up an environment on AWS that consists of a VPC with a private and public subnet following the instructions for Magento Quick Start: http://docs.aws.amazon.com/quickstart/latest/magento/architecture.html
The private subnet includes:
- an EC2 instance (web server)
- an Aurora RDS that connects to the web server
The public subnet includes:
- a bastion instance for ssh connections to the EC2 instance in the private subnet
Generally, I can connect to Aurora RDS via ssh by connecting to the bastion host, then connecting to the private EC2 instance, and then to the RDS, however this makes it hard to perform simple tasks on the RDS.
Is it possible to connect to the RDS using mySQL workbench over ssh through the bastion?
I've tried everything but nothing seems to work.