I used to connect from home with Microsoft SSMS to a Microsoft Database. Can I do the same from SQL Workbench to an Aurora database?
I read this: https://aws.amazon.com/premiumsupport/knowledge-center/connect-rds-mysql-workbench/, but to me it's fuzzy about what I'm asking. And this page seems to requires a Cloud9 Environment: https://aws.amazon.com/getting-started/tutorials/configure-connect-serverless-mysql-database-aurora/
I found my public home IPAddress and added to a "Security Group". I added /32 on the end of my home IP address to make it a CIDR address. Then I modified my serverless Aurora database to allow that security group.
But I cannot connect even with Telnet myname.cluster-c900joynbtoe.us-west-2.rds.amazonaws.com 3306.
Later I found this, which implies it is not possible: ' https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/aurora-serverless.html#aurora-serverless.limitations
I do have an EC2 instance, I might try install SQL Workbench there and give it a try (using Remote Desktop/RDP) to connect to the EC2.
Amazon provides a "serverless" option when you set up an Aurora RDS database server. There are benefits to this, but one drawback is that you cannot connect to it from anywhere outside the VPC that it resides in.
It's possible you can work around this by tunelling over SSH. An alternative would be to set Aurora up in standard, not serverless mode. Then you should be able to connect remotely with the right Security group setup.