Mysql – Unable to connect to encrypted RDS instance running MySql from workbench

amazon-web-servicesMySQLrdsremote-access

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?

enter image description here

enter image description here

enter image description here

Best Answer

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.

Related Topic