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

Question

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

Answer 1

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.