大网数据广告活动
服务器运维问答

Unable to connect to encrypted RDS instance running MySql from workbench

· 52CE 我爱测

We recently changed our production RDS instance running MySQL to an encrypted one. I am not sure if the encryption caused the issue or anything else, but now we can't remote connect to the instance through workbench. The connecti…

问题原文

原帖链接 · karamvir · CC BY-SA 3.0

We recently changed our production RDS instance running MySQL to an encrypted one. I am not sure if the encryption caused the issue or anything else, but now we can't remote connect to the instance through workbench. The connection from our Php application which is hosted on EC2 server under the same account works fine. "REQUIRE SSL" is enabled in MySql. Connection through EC2 console using mysql command is working fine. Security group is setup correctly to allow traffic from our IP. The same AWS account has a dev RDS instance which is not encrypted and connection to that one works fine. Any ideas what the issue could be?

已采纳解答

原帖链接 · Tim · CC BY-SA 3.0

First up, what's an "encrypted one". Do you mean RDS using encrypted disk? Or do you mean requiring SSL connections? Did it used to work, in the same network? What exactly have you changed since it last worked?

A few things to check:

  • Did you tick the "allow public access" tick box when you created the instance?
  • Are your security group and routing rules set up correctly? NACLs?

This isn't a full answer, but it's too long for a comment. If you can edit your question to include a lot more detail we might be able to help. Screenshots of your RDS configuration, routing, and security groups might help if you think any of them are relevant.

I have a basic tutorial on setting up RDS here.

摘自公开归档,保留原文语言,版式经整理,外部媒体与邮箱地址已移除。

资料来源与适用范围

资料来源
Server Fault
适用范围
以原帖系统、软件版本与发布日期为准(2017-08-01)
内容语言
中文;命令、路径和错误标识保留技术原文
本地收录日期
2026-11-15
授权说明
CC BY-SA 3.0

正文与所需资源由本站本地存储。查看来源及更新记录 ↗

请按适用版本和实际日志确认原因;本站没有对每一种系统或设备逐项执行文中的操作。