Sudden Drop in RDS Connections and Connection Attempt Issues

Question

I've encountered a sudden drop in connections to my RDS instance, with all connections dropping to zero. In my attempt to resolve the issue, I've taken the following steps:

1.Connection Attempts:

I tried connecting using both the bastion host method and the command line (cmd).

2.MySQL Workbench Error:

While attempting to connect via MySQL Workbench, I received the error: "Access denied for user 'username'@'using system ip' (using password: yes)."

3.Command Line Error:

In the command line, the error encountered was: "ERROR 1045 (28000): Access denied for user 'username'@'using system ip' (using password: YES)."

Answer

Hello.

Can I check the RDS error logs and general logs?  
These logs may contain logs that can help identify the cause.  
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_LogAccess.MySQL.LogFileSize.html

Also, make sure you are using the correct password.  
By the way, are you connecting as the RDS admin user?  
If you are using the user you created instead of the RDS admin user, use the command below to check whether external access is allowed in the host column.  
```
select host,user from mysql.user;
```

Answer

Sounds like you have password auto rotation on.. Turn it off or restart the application :)

Answer

Was the RDS publicly available?

Just wondering if it’s been compromised. 
You can reset the master password via the AWS console.

Sudden Drop in RDS Connections and Connection Attempt Issues

Relevant content