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. ?

已提问 4 个月前194 查看次数
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.

您未登录。 登录 发布回答。

一个好的回答可以清楚地解答问题和提供建设性反馈,并能促进提问者的职业发展。

回答问题的准则