无法连接到AWS RDS上的mysql服务器 [英] Cant connect to mysql server on AWS RDS

问题描述

我是AWS RDS的新手.我已经创建了RDS实例.但是我不知道如何连接该数据库. 我这样尝试过

I am new to AWS RDS. I have created RDS instance.But i dont know, how can i connect this DB. I tried like this

mysql -h awsinstanamehere.rds.amazonaws.com -P 3306 -u username -p

输入密码后，我遇到类似这样的错误

ERROR 2003(HY000):无法连接到MySQL服务器 'awsinstanamehere.rds.amazonaws.com'(110)

ERROR 2003 (HY000): Can't connect to MySQL server on 'awsinstanamehere.rds.amazonaws.com' (110)

需要在AWS控制台中设置任何安全设置吗?

注意: 我想为该数据库导入表

Note: I want to import tables for that DB

谢谢

推荐答案

RDS有一个安全组-在AWS控制台RDS中，有一个用于安全组的条目.

RDS has a security group - in the AWS console, RDS, there's an entry for security groups.

如果未明确创建安全组，则可能使用的是默认".每个RDS实例可能应该有一组.

If you didn't explicitly create a security group, you are probably using "default". You should probably have one group per RDS instance.

您将需要确保端口3306和本地连接所用的任何应用程序均对本地网络开放.您可以允许按IP或按安全组进行访问.

You will need to make sure that port 3306 is open to your local network, as well as whatever application you will be using to connect to it. You can allow access by IP or by security group.

这篇关于无法连接到AWS RDS上的mysql服务器的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！