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 Answer
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
EXPERT
answered 4 months ago
  • 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.

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions