aws rds mysql 连接_连接到Amazon RDS MySql的远程

最新推荐文章于 2022-11-26 12:48:04 发布

谢凌曦

最新推荐文章于 2022-11-26 12:48:04 发布

阅读量888

点赞数

文章标签： aws rds mysql 连接

本文链接：https://blog.csdn.net/weixin_33359523/article/details/113231075

版权

尝试从本地计算机使用MySQL Workbench或HeidiSql连接到Amazon RDS上的MySQL实例时，遇到错误2003（HY000）。已确保安全组允许所有流量，并且在EC2服务器上可以成功连接。问题可能在于未配置RDS以接受外部IP地址，需要在DB安全组中添加CIDR/IP范围，例如设置为0.0.0.0/0以接受所有IP。

摘要由CSDN通过智能技术生成

I've seen questions like this before but all the answers didn't work

I'm trying to connect to MySql on Amazon RDS from my computer, using MySql WorkBench, or HeidiSql or even the console Mysql.exe and i'm getting 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 Inbound rule that allows all traffic, and applied it, and still - same error.

I have no active Firewall on my computer, and have good internet access

I am able to access the DB from the Amazon EC3 server, there I am connecting using HeidiSql, and the exact same settings (host, username, password) is just not working on my computer

Thanks a lot

EDIT:

Still, nothing is working. I'm pretty sure that my security groups is configured to allow outside connections, as can be seen on the next screenshot, there is another place with firewall rules?

解决方案

The 2003 error is the Access-Denied Error I would be willing to bet that you haven't configured the RDS to accept your IP address.

This can be done by going to DB Security Groups -> Click Default -> and add a new CIDR/IP range. I believe that if you set it to 0.0.0.0/0 it will accept all ip addresses