没有不值得去解决的问题,也没有不值得去学习的技术!

Connect to an Alibaba Cloud RDS MySQL Instance Over the Public Internet

In the RDS management console, go to Data Security - Add Whitelist Group - company.

1. The public IP address for connecting to the Alibaba Cloud RDS MySQL instance has been applied for. See Figure 1.

The public IP address for connecting to the Alibaba Cloud RDS MySQL instance has been applied for.
Figure 1

2. The connection failed in Navicat for MySQL, with the error: 2003 – Can’t connect to MySQL server on ‘rm-bp’ (10060 “Unknown error”). See Figure 2.

The connection failed in Navicat for MySQL, with the error: 2003 - Can't connect to MySQL server on 'rm-bp' (10060 "Unknown error").
Figure 2

3. To access the RDS over the public network, you must use the public IP address. How to connect. Note: Public network connections reduce instance security; using an internal network address is recommended. See Figure 3.

To access the RDS over the public network, you must use the public IP address. How to connect. Note: Public network connections reduce instance security; using an internal network address is recommended.
Figure 3

4. Search for “IP” on Baidu to obtain the current company’s public IP segment. See Figure 4.

Search for "IP" on Baidu to obtain the current company's public IP segment.
Figure 4

5. In the RDS management console, go to Data Security – Add Whitelist Group – company. See Figure 5.

In the RDS management console, go to Data Security - Add Whitelist Group - company.
Figure 5

6. Testing the connection returned the error: 1045 – Access denied for usr ‘root’@’ip’ (using password: YES). See Figure 6.

Testing the connection returned the error: 1045 - Access denied for usr 'root'@'ip' (using password: YES).
Figure 6

7. Instead of using root as the username, use a different username. The connection succeeded. See Figure 7.

Instead of using root as the username, use a different username. The connection succeeded.
Figure 7

关于作者 · 持续学习与技术实践

我是一名拥有 15 年以上开发经验的技术从业者,自 2013 年起持续运营个人技术博客,记录工作与个人项目中遇到的真实问题,以及解决问题过程中的探索、实践和思考。

除了技术写作,我也在持续开发和维护自己的独立项目,探索新技术和新工具在实际场景中的应用。我始终相信,没有不值得去解决的问题,也没有不值得去学习的技术。

如果这篇文章对你有所帮助,欢迎浏览博客中的其他文章,也欢迎交流技术经验与想法。

关于我  ·  GitHub  ·  邮件联系