Connecting to Amazon RDS instance through EC2 instance using MySQL Workbench
I AWS I have a VPC set up with a Bastion Host. The bastion host is a
single EC2 instance with a public address trough which you can SSH to any
other server on the VPC.
I have created an RDS MySQL instance within the VPC and I would like to
connect to it using MySQL workbench. I have followed the steps detailed
here, however in "Step 6: Setting up remote SSH Configuration", it asks me
to "Provide the Public DNS of the Amazon EC2 instance" (i.e. the bastion
host).
MySQL workbench then does checks for certain MySQL resources on that
server. However, this is not correct in my opinion as I have provided the
bastion host's address, which does not have MySQL installed. As a result,
the last two checks for "Check location of start/stop commands" and "Check
MySQL configuration file" then fail.
I have then tried using the endpoint address of the RDS MySQL instance but
with no success (as it is in the private subnet so is not publicly
addressable).
It seems that many people have this up and running, but what am I doing
wrong here?
No comments:
Post a Comment