无法将 MySQL Workbench 连接到 RDS 实例 [英] Unable to connect MySQL Workbench to RDS instance

问题描述

我正在学习本教程

2. 确保Public Accessibility 值为是

3. 使用

   3.2.点击编辑入站规则

   3.3.单击添加新规则，然后添加具有以下值的规则:

   类型:MYSQL/Aurora.

   协议: TCP(默认)

   端口范围: 3306(默认)

   来源:我的 IP ->这将是您在

   4. 在 MySQL Workbench 中填写信息

   主机名:使用您在连接和安全方面的端点的值

   端口:使用您在连接和安全中设置的端口值，默认为 3306.

   用户名:使用您在配置中作为主用户名的值

   密码:使用您在创建数据库实例时设置的值.

   如果您忘记了密码，您可以通过在您的数据库实例中点击修改来更改密码)

   希望这也能帮到你.

   Am following this tutorial http://thoughtsandideas.wordpress.com/2012/05/17/monitoring-and-managing-amazon-rds-databases-using-mysql-workbench/

   I am not able to Test DB Connection while creating new server instance to connect to the RDS database. It says Bad_Authentication[allowed_types=public_key], i have a tried different .pem files and have done through a lot of forums. I have also allowed access to my IP in the DB SecurityGroups for RDS and the Security Groups for EC2.

   Please help me out. Thanks.

   解决方案

   This worked for me. Assuming you have logged into AWS:

   1. Go to RDS -> Databases -> Select your database

   2. Make sure the Public Accessibility value is Yes

   3. Check your IP address using http://checkip.amazonaws.com/. If it is not added to the Security Rule Groups, you should add it. this step is crucial

   3.1. Click on the rule name. This will open up a new tab, then click in the name of the rule.

   3.2. Click on Edit inbound rules

   3.3. Click on Add new rule, and add a rule with the following values:

   Type: MYSQL/Aurora.

   Protocol: TCP (default)

   Port range: 3306 (default)

   Source: My IP -> This will be the IP Address you got at http://checkip.amazonaws.com/.

   4. Fill information in MySQL Workbench

   Hostname: Use the value you have for Endpoint at Connectivity and Security

   Port: Use the value you have for Port at Connectivity and Security, by default it is 3306.

   Username: Use the value you have for master username at Configuration

   Password: Use the value you set when you created the database instance.

   If you forgot the password, you can change it by clicking on Modify in your database instance)

   I hope this also helps you.

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