无法使用MYSQL工作台连接到Amazon RDS [英] Not able to connect to amazon RDS with MYSQL workbench

问题描述

在使用MySQL工作台连接RDS实例时，我陷入了困境

I am stuck here in connecting with RDS instance with MySQL workbench

我遇到以下错误

无法连接到"visitorbook.cdokqvroltrt.us-west-2.rds.amazonaws.com"(10060)上的MySQL服务器

Can't connect to MySQL server on 'visitorbook.cdokqvroltrt.us-west- 2.rds.amazonaws.com' (10060)

我已为我的IP地址配置了安全组，用于来自IP的端口3306.

I have configured my security group for inbound traffic from my IP for port 3306.

推荐答案

将EC2实例中的 ssh隧道与您的 pem 文件一起使用.无需更改安全组.如果数据库连接可以从ec2实例运行，那么它也将在本地计算机上运行.

Use ssh tunnel through the EC2 instance with your pem file. No need to change the security group. If DB connection works form ec2 instance, then it will work from local machine as well.

您可以在工作台连接设置中设置ssh隧道选项.

You can setup ssh tunneling option in workbench connection setting.

这篇关于无法使用MYSQL工作台连接到Amazon RDS的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！