Cannot connect to my RDS (MySQL) from my local PC - Security Groups already configured properly
I have created my RDS (MySQL) instance and its status has been "availble". I have also done below:
- Selected "Publiclly accessible" from the "Public Access" section in the "Modify Instance" page;
- Modified its Security Groups to add inbound rule for "0.0.0.0/0" for port 3306.
However, after above, I still cannot connect to the RDS from my Local PC at all.. nothing to do with credentials... The RDS server is still not allowing any connection to the port 3306. Can anyone give me some guidance?
On the other hand, I have been able to connect to the RDS from my EC2 instance (Ubuntu) using mysql command line.
- Language
- English
asked 3 years ago957 views
- Newest
- Most votes
- Most comments
Hi, I would suggest you to telnet to the ip address of your machine with port 3306 and see if your tcp session gets established on this session. You should use -d (debug) option with telnet to better see if tcp session is established.
So, telnet -d -p 3306 <ip address> should allow you to clear both routing and sec group issues.
See https://netbeez.net/blog/telnet-to-test-connectivity-to-tcp/ for more details about debugging tcp with telnet
