升级后无法访问AWS RDS实例 [英] Can't Access AWS RDS Instance after Upgrade

问题描述

只需将我的MySQL RDS实例从免费层db.t2.micro升级到db.r3.large.相同的存储，相同的安全组，相同的用户组/凭据，相同的VPC，相同的终结点名称，相同的所有内容.

升级之前，我以前能够通过MySQL工作台远程访问同一实例，并且根据AWS，我的端点位置没有更改.

收到错误消息:

无法连接到'blahblah.rds.amazonaws.com'(10060)上的MySQL服务器

我尝试重新启动几次.由安全组确保在0.0.0.0/0和::/0的端口3306上允许入站TCP访问

还有什么问题吗?

解决方案

您可能需要重新启动MySQL工作台，而不是重新启动RDS.

正如我在此处所述，数据库句柄已更改，但是代码没有注意到.因此，MySQL工作台正在使用被拒绝的过时句柄.

Just upgraded my MySQL RDS instance from the free-tier db.t2.micro to an db.r3.large. Same storage, same security groups, same user groups/credentials, same VPC, same endpoint name, same everything.

I was previously able to access this same instance remotely through MySQL workbench before the upgrade, and according to AWS my endpoint location has not changed.

The error message received:

Can't connect to MySQL server on 'blahblah.rds.amazonaws.com' (10060)

I've tried restarting several times. Ensured by security group allowed inbound TCP access on port 3306 for both 0.0.0.0/0 and ::/0

What else could be wrong?

解决方案

You probably need to restart the MySQL workbench, not reboot the RDS.

As I described here, the database handles have changed, but the code doesn't notice. So the MySQL workbench is using outdated handles that are being rejected.

这篇关于升级后无法访问AWS RDS实例的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！