You can connect to an RDS instance through the MySQL client.
RDS for MySQL is fully compatible with MySQL, so you can connect to your RDS instance in the way you connect to an on-premises MySQL server. This document introduces the connection procedure by taking the MySQL-Front client as an example. When connecting to an RDS instance, use an intranet or Internet address as follows:
If your client is deployed on an ECS instance that is in the same region and has the same network type as your RDS instance, use the intranet IP address.
In other cases, use the Internet IP address.
Log on with a client
- In the RDS whitelist, add the IP address of the computer that runs the client. For information about how to set the whitelist, see Set a whitelist.
- Start the MySQL-Front client.
- In the Open Connection window, click New, as shown in the following figure.
- Enter the RDS connection information.
- Description Name: Enter the connection task name. It is the same as the Host field by default.
- Host: Enter the intranet or Internet IP address allowed to access the RDS instance by referring to Background information of this document. You can view the address and port information as follows:
- Log on to the RDS console.
- Select the region where the target instance is located.
- Click the ID of the instance to visit the Basic Information page.
- In the Basic Information area, you can find the Internet and intranet IP addresses and port numbers.
- Port: Enter the intranet port number if you use an intranet connection. Enter the Internet port number if you use an Internet connection.
- User: Enter an account name of the RDS instance.
- Password: Enter the account password of the RDS instance.
- Click OK.
- In the Open Connection window, select the connection task that you created and click Open. If the connection information is correct, the RDS instance gets connected successfully.