When a MySQL-client tries to connect to mysql server over AWS cloud, mysql-server sends back an error “RDS : ERROR 2003 (HY000): Can’t connect to MySQL server (10060)” . This error states that the inbound/outbound traffic from AWS instance is not reachable to the current host where you are running your MySQL-client. So first a user need to register his public IP address in the RDS security groups to get access over the RDS MySQL instance.
Steps to configure public IP address in security groups
Following are few steps with appropriate screenshots which hep you to fix above ( “RDS : ERROR 2003 (HY000): Can’t connect to MySQL server (10060)” ) issue.
- First and for most find the public IP address for your host machine where you are running mysql-client. If you are using Amazon EC2 instance you can find your public IP here in below screenshot
- Go to the security groups and add the public IP address of your machine for inbound traffic as given in below screenshot
- Add the same entry for outbound traffic distributed by AWS services
- After making above entries refresh your security groups and test your connection from any mysql-client. For example, you can test your connection by simply typing below command from any terminal where mysql is configured
mysql -h host-public-ip/DNS -P 3306 -u username -p password
we are open to any suggestion because it can improve a bit more. ww.ease2code.com
Speak Your Mind