Unable to Connect to RDS Instance After Endpoint Address Change after restore

Question

I would like to ask why, after restoring a snapshot in RDS and naming it differently, I am unable to connect. The original instance was named 'mysql8', and after the restoration, it became 'mysql8-test.

I am using MySQL Workbench to connect, but still unable to establish a connection. What should I do to troubleshoot this?

I have confirmed that the VPC is the same as before, but the only difference is that the endpoint address has changed.

Does anyone know the reason for this?

parkht · Answer

First of all, you need to verify DNS resolution as below.

At the client,  
`$ dig  +short`

Indeed, need to make sure that the mysql port is opened, the inbound and outbound 3306 port.   
Please share with me the more detailed situation to troubleshoot if it doesn't work.

**Connecting to a DB instance running the MySQL database engine**
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_ConnectToInstance.html

Unable to Connect to RDS Instance After Endpoint Address Change after restore

Add your answer

Relevant content