如何将 MySQL Workbench 连接到 Amazon RDS?

How to connect MySQL Workbench to Amazon RDS?(如何将 MySQL Workbench 连接到 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.

• 连接名称 – 提供一个名称来标识您的连接连接方法 – 从下拉菜单中选择 Standard TCP/IP over SSH向下列表而不是标准(TCP/IP).然后在出现的两个选项卡式窗格中，填写在参数"选项卡下找到的以下值.
• SSH 主机名 – 提供 Amazon EC2 实例的公共 DNS(参见图 3)将用作中间服务器用于创建与数据库实例的连接的实例.
• SSH 用户名 – 提供 Amazon EC2 实例的用户(参见图 3)，该实例将用作中间服务器实例，用于创建与数据库实例的连接.
• SSH 密钥文件 – 提供用于连接的私钥 (xxx.pem)通过 SSH 的 Amazon EC2 实例
• 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).

密码 – 单击在钥匙串中存储.. 按钮并输入在 Amazon RDS 中创建数据库实例时提供的密码.

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

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