SQL Workbench connection

Based on the error message shown in the image, it appears you're encountering a connection issue when trying to connect SQL Workbench to an AWS RDS instance. The error suggests that the target machine (your RDS instance) is actively refusing the connection. This type of error is often related to security settings or incorrect connection parameters. Here are some steps to troubleshoot and potentially resolve the issue:

1. Verify your connection details:

   • Ensure you're using the correct endpoint for your RDS instance.
   • Double-check that you're using the right port number (typically 3306 for MySQL).
   • Confirm that your username and password are correct.

2. Check your RDS instance configuration:

   • Make sure your RDS instance is set to be publicly accessible if you're connecting from outside the VPC.
   • Verify that the instance is in an "available" state in the AWS Management Console.

3. Review your security group settings:

   • Check that the security group associated with your RDS instance allows inbound traffic on the database port (3306 for MySQL) from your IP address.

4. Network and firewall settings:

   • Ensure your local firewall or network isn't blocking outbound connections to the database port.
   • If you're on a corporate network, check with your IT department about any potential restrictions.

5. VPC and subnet configuration:

   • If your RDS instance is intended to be publicly accessible, make sure it's in a public subnet with a route to an Internet Gateway.

6. Version compatibility:

   • Verify that the SQL Workbench version you're using is compatible with the MySQL version running on your RDS instance.

If you've verified all these points and are still unable to connect, you might want to try connecting using a command-line MySQL client to isolate whether the issue is specific to SQL Workbench or a more general connectivity problem.

Remember, exposing your database to the public internet can pose security risks. For production use, consider more secure access methods like AWS VPN or Direct Connect.
Sources
Troubleshooting Connection Issues Between MySQL Workbench and AWS RDS | AWS re:Post
Msql workbench 無法練線 rds mysql | AWS re:Post
Connecting AWS Rds with my My SQL Workbench | AWS re:Post