I have a MySQL RDS DB Instance but now I cannot see it supportedpatient.cx71ia97qvpz.us-west-1.rds.amazonaws.com

0

I had a MySQL RDS DB Instance but now I cannot see it supportedpatient.cx71ia97qvpz.us-west-1.rds.amazonaws.com and I caanot access it.

I had some past due billing for 2 months but I have already paid right now, how much time this will take to be restored ? how to restore my MySQL Database. ?

1개 답변
0

Hello.

Is the region opened in the management console correct?
Looking at the endpoint, it looks like it was created in the "us-west-1" region.
Do you have the "us-west-1" region open?
Also, check all regions and if RDS does not exist, it may have been deleted.
In that case, you will need to restore from the snapshot.
If there are no snapshots left, you cannot restore them.
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_RestoreFromSnapshot.html

profile picture
전문가
답변함 4달 전
  • Hi @Riku, Thanks for yor response, answer this helps, I was able to restore the Databse from the snapshot but now I have a weird situation with my app

    When I run my app and the database locally from my computer all is working fine, the application connects, But when I run my app pointing to the AWS MYSQL Database host supportedpatient.cx71ia97qvpz.us-west-1.rds.amazonaws.com an error occurs {"error":"unsupported_grant_type"}

    But the weird thing is that I can connect to the DB using Workbench.

    What could be the issue here ?

  • I feel like it's not a connection problem to RDS. Please check the application log etc. to see if a more detailed error is output.

  • Hi @Riku_Kobayashi Thanks

    this is the error when trying to connect

    This connection was immediately refused by the server. Most likely this is because the MySQL server does not allow remote connections to it

    Function Value mysqli_connect_errno() 2002 mysqli_connect_error() Connection refused mysqli_get_client_version() 50012

    How to allow remote connections from my Web App ?

    right now it only connects using MySQL Workbench but not the app.

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

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

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