Unable to connect to AWS mysql RDS instance
0
votes
0
answers
172
views
I created an AWS mySQL RDS instance (free tier), but i am unable to connect to it from workbench or cli. I have enabled public access to the DB while creation and allowed "All traffic" while trying to debug. Following are the DB details -
The DB is configured to use the default security group
Following is the error i get when i try accessing via cli


MySQL JS > \connect admin@db.abcd.ap-south-1.rds.amazonaws.com:3306
Creating a session to 'admin@db.abcd.ap-south-1.rds.amazonaws.com:3306'
Enter password:
MySQL Error 2003 (Can't connect to MySQL server on '..ap-south-1.rds.amazonaws.com' (60)): HY000
I used telnet to check connectivity but got an error -
telnet db.abcd.ap-south-1.rds.amazonaws.com 3306
db.abcd.ap-south-1.rds.amazonaws.com: nodename nor servname provided, or not known
I am new to AWS and this seems like an easy thing. Can you pls help me with fixing this?
Asked by Ankit Rustagi
(101 rep)
Jan 24, 2024, 02:27 PM