Intellipaat Back

Explore Courses Blog Tutorials Interview Questions
0 votes
2 views
in AWS by (19.1k points)

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

So in order 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 a security group I specified for mysql and for all connection. Still, after I remotely logged into the instance and try to connect to the endpoint 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 the Asia Pacific (Singapore) region since I am a resident of India.

1 Answer

+1 vote
by (44.4k points)

It should work fine if you remove the port number at the end.

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

Related questions

Want to get 50% Hike on your Salary?

Learn how we helped 50,000+ professionals like you !

31k questions

32.8k answers

501 comments

693 users

Browse Categories

...