- Newest
- Most votes
- Most comments
Hello.
Have you checked the RDS MySQL error log?
For example, if an error like "Host 'yyy.yyy.yyy.yyy' is blocked because of many connection errors;" occurs, it may be blocked due to too many connection failures.
If such an error occurs, it may be resolved by executing the "FLUSH HOSTS;" command as described in the document below.
https://repost.aws/ja/knowledge-center/rds-blocked-host-error
Hi - Thank you for your reply.
I don't see any error messages like that.
If I try to connect to MySQL I see the following response:
ERROR 2002 (HY000): Can't connect to MySQL server on '---.---.rds.amazonaws.com' (115)
The exact command works from a different location.
Similarly with telnet:
telnet ---.---.rds.amazonaws.com 111111
Trying 3.11.---.---...
telnet: connect to address 3.11.---.---:
Connection refused
But from a different IP, I see a connection:
telnet ---.---.rds.amazonaws.com 111111
Trying 3.11.---.---...
Connected to ---.---.compute.amazonaws.com.
Thanks, Gary.
The RDS MySQL error log just shows the following warning:
"Plugin mysql_native_password reported: ''mysql_native_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'"
I think our access to the RDS instance is being blocked at a higher level, ie before we hit the RDS instance - is there any way we can find out if this is the case?
Relevant content
- asked 8 months ago
- AWS OFFICIALUpdated 2 years ago
- AWS OFFICIALUpdated 3 years ago
- AWS OFFICIALUpdated 3 years ago
What I would like you to check is the RDS MySQL error log. Please check the error log output to RDS as the error message displayed at connection time alone cannot resolve the issue. https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_LogAccess.MySQL.LogFileSize.html#USER_LogAccess.MySQL.Errorlog
If nothing is output to the error log even after connecting, it is possible that the connection to RDS is not permitted by the security group, network ACL, OS firewall, or firewall of the connection source.