如何将MySQL Workbench连接到Amazon RDS？ [英] How to connect MySQL Workbench to Amazon RDS?

问题描述

我正在访问Putty的Amazon RDS（MySQL）。 MySQL Workbench仅通过SSH命令行工作，但我想直接从MySQL Workbench访问云MySQL主机数据库。

I am accessing the Amazon RDS (MySQL) from Putty. MySQL Workbench works through SSH commandline only, but I would like to access the cloud MySQL host database directly from MySQL Workbench.

推荐答案

MySQL论坛是一个发布，链接到各种来源连接MySQL Workbench到在线资源： http://forums.mysql.com/read.php?152,252640,252640#msg-252640 。 Amazon RDS的基本步骤在此页面上： https://thoughtsandideas.wordpress.com/2012/05/17/monitoring-and-managing-amazon-rds-databases-using-mysql-workbench/

In the MySQL forums is a posting that links to various sources for connecting MySQL Workbench to online resources: http://forums.mysql.com/read.php?152,252640,252640#msg-252640. The essential steps for Amazon RDS are on this page: https://thoughtsandideas.wordpress.com/2012/05/17/monitoring-and-managing-amazon-rds-databases-using-mysql-workbench/

步骤3）填写如下所示的值，如图4所示。

Step 3) Fill in the values as described below which illustrated in Figure 4.

• 连接名称 - 提供用于标识您的连接的名称
  连接方法 - 从下拉列表中选择标准TCP / IP，而不是标准（TCP / IP）。


• SSH主机名 - 提供Amazon EC2 instace的公共DNS
  （参见图3）将用作中间服务器
  用于创建与数据库实例的连接的实例。


• SSH用户名 - 提供Amazon EC2实例的用户（参见图3）将用作用于创建与数据库实例的连接的中间服务器实例。


• SSH密钥文件 - 提供用于连接
  的私钥（xxx.pem） EC2 instace via SSH


• MySQL主机名 - 提供在Amazon RDS中创建的数据库实例的端点（参见图5）。



• 用户名 - 提供在Amazon RDS中创建的数据库实例的主用户名（参见图5）。

• Connection Name – Provide a name to identify your connection Connection Method – Select Standard TCP/IP over SSH from the drop down list instead of Standard(TCP/IP). Then on the appearing two tabbed pane, fill the following values found under Parameters tab.
• SSH Hostname – Provide the Public DNS of the Amazon EC2 instace (refer Figure 3) which will be used as the intermediate server instance used to create the connection with the DB instance.
• SSH Username – Provide the user of the Amazon EC2 instance (refer Figure 3) which will be used as the intermediate server instance used to create the connection with the DB instance.
• SSH Key File – Provide the Private Key (xxx.pem) used to connect Amazon EC2 instace via SSH
• MySQL Hostname – Provide the Endpoint of the DB instance created in Amazon RDS(refer Figure 5).

• Username – Provide the Master Username of the DB instance created in Amazon RDS(refer Figure 5).

密码 - 在Keychain ..

Password – Click on Store in Keychain.. button and type the password provided while creating the DB instance in Amazon RDS.

这篇关于如何将MySQL Workbench连接到Amazon RDS？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！