通过使用MySQL Workbench的EC2实例连接到Amazon RDS实例 [英] Connecting to Amazon RDS instance through EC2 instance using MySQL Workbench
问题描述
在AWS我有一个VPC设置了一个堡垒主机。堡垒主机是一个公共广播槽，你可以SSH在VPC的任何其他服务器的单一EC2实例。
In 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.
我所创建的VPC中的RDS MySQL实例，我想使用MySQL工作台连接到它。我跟了详细的<一个步骤href="http://thoughtsandideas.word$p$pss.com/2012/05/17/monitoring-and-managing-amazon-rds-databases-using-mysql-workbench/"相对=nofollow>此处，然而，在第6步：设置SSH远程配置，它要求我以提供Amazon EC2实例的公共DNS（即堡垒主机）
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的工作台上，然后做检查该服务器上的某些MySQL的资源。然而，这是不是在我看来，正确的，因为我所提供的堡垒主机的地址，它没有安装了MySQL。其结果是，最后两检查检查开始的位置/ stop命令和检查MySQL配置文件，然后失败。
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.
我又试图使用RDS MySQL实例没有成功，但与端点地址（因为它是在私人子网，以便公众无法寻址）。
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?
推荐答案
我一直挣扎着类似现在周的东西。只要理解了它几分钟前。
I've been struggling with something similar for weeks now. Just figured it out a few minutes ago.
- 在mysql的工作平台，创建一个新的服务器实例。
- 对于远程主机地址，输入您的端点地址（即xxxxxx.us-east-1.rds.amazonaws.com）
- 对于连接方法，选择标准TCP / IP通过SSH
- 的SSH主机名是你的EC2实例的公共DNS
- 在我指定的EC2用户（我相信通过EC2实例类型而异）作为用户名，然后指定相应的实例是使用密钥对所下载的密钥文件。
- MySQL的主机名是RDS实例的端点。
- 的用户名是用户名的RDS实例（即ebroot）
使用，我是能够连接。不过，我没有使用VPC在我的设置。希望这可以帮助。祝你好运！
Using that I was able to connect. However, I did not utilize VPC in my setup. Hope this helps. Good luck!
这篇关于通过使用MySQL Workbench的EC2实例连接到Amazon RDS实例的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
