错误2005(HY000):aws中的未知MySQL服务器主机 [英] ERROR 2005 (HY000): Unknown MySQL server host in aws

问题描述

我已经用angular js创建了一个电子商务网站.而且我需要在亚马逊网络服务中托管相同的内容.

I have created an e-commerce site in angular js. And I need to host the same in amazon web service.

因此，为了托管相同的主机，我首先创建了一个ec2实例.现在，在此之后，通过允许所有ip出站和入站，在rds实例中添加了VPC安全组.在创建安全组时，我为mysql和所有连接指定了安全组. 仍然在我远程登录到实例并尝试使用

So inorder to host the same I created an ec2 instance first. Now after that added an rds instance with a security group of VPC by allowing all ip's as outbound and inbound. While creating security group I specified for mysql and for all connection. Still after I remotely loged into the instance and try to connect to the end point from rds instance using

mysql -u username -p password -h ********.ap-southeast-1.rds.amazonaws.com:3306

我得到一个错误

ERROR 2005 (HY000): Unknown MySQL server host xxxxxxxxx (0)

由于我是印度居民，所以我是从亚太地区(新加坡)创建的实例.

I created the instance from Asia Pacific (singapore) region since I am a resident of india.

推荐答案

应为 ********.ap-southeast-1.rds.amazonaws.com 而不是********.ap-southeast-1.rds.amazonaws.com:3306

您不需要最后的端口号.

You do not need the port number in the end.

这篇关于错误2005(HY000):aws中的未知MySQL服务器主机的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！