无法从 EC2 实例连接到 RDS 实例

Can#39;t connect to RDS instance from EC2 instance(无法从 EC2 实例连接到 RDS 实例)
本文介绍了无法从 EC2 实例连接到 RDS 实例的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

从 EC2 实例 i-78a8df00,我正在尝试连接到 RDS 实例 mysql.************.us-east-1.rds.amazonaws.com.他们都在美国东部地区.我将 EC2 实例的安全组 (sg-********) 添加到 RDS 安全组,但这没有帮助.这似乎是防火墙/DNS 问题,因为它在运行此命令时超时:

ubuntu@ip-10-195-189-237:~$ mysql -h mysql.************.us-east-1.rds.amazonaws.com

<块引用>

错误 2003 (HY000):无法连接到mysql.************.us-east-1.rds.amazonaws.com"上的 MySQL 服务器 (110)

我可以使用与上面相同的线路从我的本地机器连接到 RDS 实例.我尝试了各种论坛解决方案,但都无济于事.

解决方案

看起来在上次发布和本次发布之间的某个时间,Amazon 修复了 DNS 路由问题,因为现在对于多可用区 rds 一切正常...

From EC2 instance i-78a8df00, I'm trying to connect to RDS instance mysql.************.us-east-1.rds.amazonaws.com. They are both in the U.S. East region. I added the security group of EC2 instance (sg-********) to the RDS security group, but that didn't help. It appears to be a firewall/DNS issue as it is timing out when running this command:

ubuntu@ip-10-195-189-237:~$ mysql -h mysql.************.us-east-1.rds.amazonaws.com

ERROR 2003 (HY000): Can't connect to MySQL server on 'mysql.************.us-east-1.rds.amazonaws.com' (110)

I can connect to RDS instance fine from my local machine using the same line as above. I tried various forum solutions but those don't help.

解决方案

Looks like sometime between the last posting and this posting, Amazon fixed the DNS routing issue, because everything works fine now for multi-AZ rds...

这篇关于无法从 EC2 实例连接到 RDS 实例的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持编程学习网!

本站部分内容来源互联网,如果有图片或者内容侵犯您的权益请联系我们删除!

相关文档推荐

Hibernate reactive No Vert.x context active in aws rds(AWS RDS中的休眠反应性非Vert.x上下文处于活动状态)
Bulk insert with mysql2 and NodeJs throws 500(使用mysql2和NodeJS的大容量插入抛出500)
Flask + PyMySQL giving error no attribute #39;settimeout#39;(FlASK+PyMySQL给出错误,没有属性#39;setTimeout#39;)
auto_increment column for a group of rows?(一组行的AUTO_INCREMENT列?)
Sort by ID DESC(按ID代码排序)
SQL/MySQL: split a quantity value into multiple rows by date(SQL/MySQL:按日期将数量值拆分为多行)