I've set up a DB Instance on AWS, and looking around all the guides I should now be able to go on MySQL Workbench and connect it succesfully, as I have a hostname, port, user ID and password.
However, when I enter all the details I specified when creating the instance, I get the error:
Failed to Connect to MySQL at with user
then below it says the same error with (10060) in brackets. I looked up this error but couldn't find any relevant solution.
Two common causes of connection failures to a new DB instance are:
The DB instance was created using a security group that does not authorize connections from the device or Amazon EC2 instance where the MySQL application or utility is running. If the DB instance was created in a VPC, it must have a VPC security group that authorizes the connections. If the DB instance was created outside of a VPC, it must have a DB security group that authorizes the connections.
The DB instance was created using the default port of 3306, and your company has firewall rules blocking connections to that port from devices in your company network. To fix this failure, recreate the instance with a different port.
You can use SSL encryption on connections to an Amazon RDS MySQL DB instance. For information, see Using SSL with a MySQL DB Instance.
I recommend to go through below document, it will help to fix your issue.
Connecting to a DB Instance Running the MySQL Database Engine
The error code 10060 indicates connectivity problem, look into these settings / configuration -
