Stuck with AWS “ERROR 2003 (HY000) Can’t connect to MySQL server”? We can help you.
Often when a MySQL client tries to connect to MySQL server over AWS cloud, mysql-server sends back the error.
Here at Bobcares, we often handle requests from our customers to fix similar errors as a part of our Server Management Services. Today we will see how our support engineers fix this for our customers.
How to fix AWS ERROR 2003 (HY000) Can’t connect to MySQL server
Before going into the steps for fixing this error we will see what causes this error.
A typical error may look like the one given below:
This error states that the inbound/outbound traffic from the AWS instance is not reachable to the current host where the MySQL client is running. So first a user needs to register the public IP address in the RDS security groups to get access over the RDS MySQL instance.
Steps to fix this error
Configuring public IP address in security groups will fix “RDS : ERROR 2003 (HY000): Can’t connect to MySQL server (10060)”.
Following are the steps to configure public IP addresses in security groups:
1. First, we must find the public IP address for our host machine where we are running mysql-client.
2. Then go to the security groups and add the public IP address for inbound traffic.
3. After that we will add the same entry for outbound traffic distributed by AWS services.
4. Once we complete the above entries we can refresh the security groups and test the connection from any mysql-client.
For example, we can test the connection by simply typing the below command from any terminal where MySQL is configured:
mysql -h host-public-ip/DNS -P 3306 -u username -p password
[Need assistance? We can help you]
In short, we saw how our Support Techs fix AWS “ERROR 2003 (HY000): Can’t connect to MySQL server” for our customers.