Connect to Amazon RDS MySql remotely

Question

I try to connect to MySql on Amazon RDS from my computer using MySql WorkBench, or HeidiSqlor even console Mysql.exe, and I get this error all the time:

ERROR 2003 (HY000): Can't connect to MySQL server on 'MY-SERVER-NAME' (10060)

• In the Security group of the instance, I created a new Inbox rule that allows all traffic and applies it, and still the same error.
• I do not have an active firewall on my computer and good internet access.
• I can access the database from the Amazon EC3 server, I connect using HeidiSql there, and the exact same settings (host, username, password) just do not work on my computer.

However, nothing works. I am sure that my security groups are configured to allow external connections, as can be seen in the following screenshot, is there another place with firewall rules?

Answer 1

I had the same problem when using an RDS instance on a VPC that I wanted to connect remotely. To fix the problem, I needed to do the following:

• Go to the VPC Management Console in AWS
• Go to Internet gateways (on the left side)
• Create and connect an Internet gateway to my VPC. Pay attention to the identifier of this gateway.
• Go to Route Tables
• Change the route table associated with the subnets associated with your RDS instance
• Add route:
  • : 0.0.0.0/0
  • : -

, VPC , , .

. , IP-.

Answer 2

2003 - . , RDS IP-.

, → " " → CIDR/IP. , 0.0.0.0/0, IP-.

Answer 3

SQLyog Amazon RDS .

: http://blog.webyog.com/2009/11/06/amazon-rds-the-beginners-guide/

Answer 4

- . telnet MySQL , , .

, MySQL IP-. root/, EC2, , , , , . , :

http://dev.mysql.com/doc/refman/5.1/en/grant.html http://dev.mysql.com/doc/refman/5.1/en/adding-users.html http://dev.mysql.com/doc/refman/5.0/en/access-denied.html

Answer 5

RDS? , RDS.

Answer 6

. Google " IP?" ; 209.x.y.z. checkip.amazonaws.com, ; 199.a.b.c.

VPC Security 209.x.y.z, , 199.a.b.c.

199.a.b.c .