How to resolve the error 'Unable to connect any of the specified MySQL hosts' while connecting Amazon RDS MySQL Database

When connecting an AWS RDS MySQL database to Bold BI data source, you may encounter an error stating “Unable to connect any of the specified MySQL hosts.” This issue may arise due to a few possible reasons. In this article, we will discuss these reasons and provide solutions to resolve the issue.

Possible Reasons and Solutions

1. Invalid Port Number: Ensure that the port number specified is a valid one. You can find the correct port number in the AWS RDS console under the “Connectivity & Security” tab of your RDS instance.

2. Public Access Not Enabled: Check if public access is enabled for your Amazon RDS instance.

3. Unable to Access Amazon RDS from Other Client Applications: Verify if you can access the Amazon RDS from any other client applications. If not, there might be an issue with your RDS instance or network configuration. Check your security group settings and ensure that the appropriate inbound and outbound rules are in place.

4. White list the IP address: If you are using Bold BI in cloud environment, please make sure to white list the IP addresses mentioned in this link.

If you still face issues connecting your AWS RDS MySQL database to Bold BI data source, please reach out to our support team for further assistance.

Additional References

• Bold BI Data Sources
• Amazon RDS User Guide
• Configuring Security Group for Amazon RDS