In this post, you will learn about the solution to the error, AWS Error 2003: Can’t Connect to RDS MySQL Server, which you may come across while trying to connect AWS MySQL RDS server from your local machine (laptop or desktop).
I came across this error when I first created an RDS MySQL instance using AWS console and tried accessing the instance from my laptop using the command such as mysql -h endpoint_address -P 3306 -u username -p. The following represents the error:
As a matter of fact, I have come across this error once in a while trying to connect the MySQL database app from the command prompt or the application. The solution works everytime you get this connection 2003 error.
Solution to the AWS 2003 Error
The following is the solution to this error:
- Go to your MySQL RDS page. Find the “Connect” section of the page. Pay attention to the details such as Endpoint, port and, security groups.
- Click on the security group, rds-launch-wizard-1 (sg-xxxxx) of type CIDR/IP – Inbound. Check the rule which provides the IP address (184.108.40.206/32) from which the connections are allowed. This is where the trick is. You are trying to access the MySQL database from IP address which does not fall within the mentioned IP range.
- In order to fix this, click on the link, rds-launch-wizard-1 related to CIDR/IP inbound. It would open up the following page:
- Click on the Inbound tab. Then, click on Edit button. It opens up the following page. Click on Source drop-down and select the option “My IP” and save.
- Try connecting the database again. You should be able to connect to the database.
In this post, you learned about fixing the error such as AWS 2003 error – Can’t connect to MySQL server. Did you find this article useful? Do you have any questions or suggestions about this article? Leave a comment and ask your questions and I shall do my best to address your queries.
He has also authored the book, Building Web Apps with Spring 5 and Angular.
Latest posts by Ajitesh Kumar (see all)
- Unit Tests & Data Coverage for Machine Learning Models - May 11, 2019
- ML Models Confusion Matrix Explained with Examples - March 30, 2019
- Machine Learning Cheat sheet (Stanford) - March 23, 2019