ERROR 2005 (HY000): Unknown MySQL server host in aws

mysql amazon-web-services amazon-ec2 amazon-rds amazon-vpc
Riyas TK picture Riyas TK · Sep 4, 2014 · Viewed 25.1k times · Source

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

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

I get an error

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.

Answer

slayedbylucifer picture slayedbylucifer · Sep 4, 2014

It should be ********.ap-southeast-1.rds.amazonaws.com instead of ********.ap-southeast-1.rds.amazonaws.com:3306

You do not need the port number in the end.

Related questions

MySQL/Amazon RDS error: "you do not have SUPER privileges..."

I'm attempting to copy my mysql database from an Amazon EC2 to an RDS: I successfully did a mysqldump of my database into my root folder using this: root@ip-xx-xx-xx-xx:~# mysqldump my_database -u my_username -p > my_database.…

Read More
How to export database from Amazon RDS MySQL instance to local instance?

AWS documentation has this page that talks about importing and exporting data from MySQL server, but it's mostly about import. The only thing I see in their documentation is a way to export 5.6 data using replication, which is documented here. …

Read More
Can't connect to RDS instance from EC2 instance

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 …

Read More