ERROR 2003 HY000 Can t connect to MySQL server on mydatabase cn5kssisqx6k ap-south-1 rds amazonaws com 110 Connection timed out

0 votes

Hi Guys,

I have launched one RDS instance in AWS. But when I tried to connect to this database from my local system, it is showing me the below error.

$ mysql -h mydatabase.cn5kssisqx6k.ap-south-1.rds.amazonaws.com -u admin -p
Enter password:
ERROR 2003 (HY000): Can't connect to MySQL server on 'mydatabase.cn5kssisqx6k.ap-south-1.rds.amazonaws.com' (110 "Connection timed out")
You have mail in /var/spool/mail/root

Jul 26, 2020 in AWS by akhtar
• 38,260 points
8,265 views

1 answer to this question.

0 votes

Hi@akhtar,

I think there is a problem with your security group. In your security group, you have to write an inbound rule for MySQL client. By default, MySQL works on 3306 port no. So you have to allow this port no.

For details, You can even check out the details of Migrating to AWS with the AWS Cloud Migration.

answered Jul 26, 2020 by MD
• 95,460 points

Related Questions In AWS

0 votes
1 answer

Can we use Terraform to execute SQL script on RDS MySQL?

I don't think remote-exec is what you ...READ MORE

answered Aug 21, 2018 in AWS by Priyaj
• 58,020 points
11,192 views
+1 vote
1 answer
0 votes
1 answer
0 votes
1 answer

Creating A New MySQL User In Amazon RDS Environment

AWS RDS security groups documentation (a common ...READ MORE

answered Jul 18, 2018 in AWS by Priyaj
• 58,020 points
2,080 views
0 votes
1 answer
0 votes
1 answer

ERROR 1006 (HY000): Can't create database 'test' (errno: 2) in mysql

Hi@akhtar, You have to change the permissions or ...READ MORE

answered Apr 14, 2020 in Database by MD
• 95,460 points
8,216 views
0 votes
1 answer

How to install MySQL in Linux system?

Hi@akhtar, You need to install the software for ...READ MORE

answered Jul 26, 2020 in Linux Administration by MD
• 95,460 points
867 views
0 votes
1 answer

Network error: Connection timed out or Error connecting to [instance] in AWS.

Hi@akhtar, Check your security group rules. You need ...READ MORE

answered Apr 28, 2020 in AWS by MD
• 95,460 points
3,612 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP