如何将 MySQL Workbench 连接到 Amazon RDS?

2021-12-23 00:00:00 ssh database mysql mysql-workbench mysqladministrator

我正在从 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.

相关文章