Cannot connect remotely to serverless Aurora MySQL

0

I have recently created a serverless Aurora MySQL DB in our account. I am attempting to connect to it remotely via mysql-workbench in order to setup the schema, etc. However, I cannot seem to establish the connection. As this document (https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/CHAP_GettingStarted.CreatingConnecting.MySQL.html ) recommends connecting via mysql command line following creation, I assume either command line or mysql-workbench are the recommended/common approaches.

I am attempting to follow the steps under the 'A DB Instance in a VPC Accessed by a Client Application Through the Internet' section of this document: https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_VPC.Scenarios.html#USER_VPC.Scenario4

The associate Aurora security group appears to allow the 3306 port through, but I am still unable to connect: Your connection attempt failed...

What am I missing to allow these connections please?

skidvd
已提问 5 年前622 查看次数
1 回答
0

Short answer: Aurora Serverless is not accessible via a public IP - it is one of the documented limitations of Aurora serverless: https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/aurora-serverless.html#aurora-serverless.limitations

Either access via an EC2 instance within the VPC and/or potentially investigate ssh tunneling to provide access through such an EC2 instance to a local machine as a work around.

skidvd
已回答 5 年前

您未登录。 登录 发布回答。

一个好的回答可以清楚地解答问题和提供建设性反馈,并能促进提问者的职业发展。

回答问题的准则