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,170 points
2,000 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.

answered Jul 26, 2020 by MD
• 95,180 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,120 points
6,301 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,120 points
1,139 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,180 points
1,948 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,180 points
124 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,180 points
1,405 views