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 年前檢視次數 621 次
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 年前

您尚未登入。 登入 去張貼答案。

一個好的回答可以清楚地回答問題並提供建設性的意見回饋,同時有助於提問者的專業成長。

回答問題指南