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년 전

로그인하지 않았습니다. 로그인해야 답변을 게시할 수 있습니다.

좋은 답변은 질문에 명확하게 답하고 건설적인 피드백을 제공하며 질문자의 전문적인 성장을 장려합니다.

질문 답변하기에 대한 가이드라인