External network connection to Alibaba Cloud RDS MySQL instance

1. The external network address of the Alibaba Cloud RDS MySQL instance has been applied to connect. as shown in Figure 1

Figure 1

2. Failed to connect in Navicat for MySQL, error: 2003 – CANT connect to mysql server onRM-BP(10060 “Unknown Error”). as shown in Figure 2

Figure 2

3. To access RDS through the external network, you need to use the external network address. How to connect. Note: The external network connection will reduce the security of the instance, and it is recommended to use the intranet address. as shown in Figure 3

Figure 3

4. Search in Baidu: IP, get the current company’s public network segment. as shown in Figure 4

Figure 4

5. In the RDS Management Console – Data Security – Add Whitelist Group – Company. as shown in Figure 5

Figure 5

6. Test connection, error: 1045 – access denied for usrrootatIP(using password: yes). as shown in Figure 6

Figure 6

7. The username is not used: root, use other usernames. The connection was successful. as shown in Figure 7

Figure 7