Connect to an instance

Last Updated: Jul 18, 2017

You can connect to an RDS instance through a MySQL client. This article introduces the connection procedure by taking the MySQL-Front client as an example.

Background information

Since RDS for MySQL is fully compatible with MySQL, the same method may be used to connect to the database. This article takes the MySQL-Front client as an example to connect to an RDS instance. You can refer to this method when using other clients. When you connect to an RDS instance through clients, pay attention to the following information on the selection of the connection address.

  • Use the Intranet address when your client is installed on the ECS that is located in the same region and the same network type with those of the RDS instance to be connected.

  • Use the Internet address for the other situations.

Operation procedure

  1. Add the IP address accessing the RDS instance to RDS white list. For more information on how to set white list, see Set the white list.

  2. Launch MySQL-Front client.

  3. In the Open Connection window, click New, as shown in the following figure.

  4. Enter the information of the RDS instance to be connected, as shown in the following figure.

    Parameters description:

    • Description Name: refers to the task name for MySQL-Front to connect each database. If you do not name this task, it is the same with the Host by default.

    • Host: refers to the connection address. If your client accesses the RDS instance through the Intranet, enter the Intranet address of the RDS instance. If your client accesses the RDS instance through the Internet, enter the Internet address of the RDS instance. The following operation steps show how to check the connection address and the port information of the RDS instance.

      1. Log on to the RDS Console.

      2. Select the region where the target instance is located.

      3. Click the ID of the instance to visit the Basic Information page.

      4. In the Basic Information area, you can find the Internet/Intranet address and Internet/Intranet port number of the instance, as shown in the following figure.

        View the basic information of the instance

    • Port: refers to the port number of the RDS instance. If your application accesses the RDS instance by using the Intranet, enter the Intranet port number of the RDS instance. If your application accesses the RDS instance by using the Internet, enter the Internet port number of the RDS instance.

    • User: refers to the account name accessing the RDS instance.

    • Password: refers to the password corresponding to the account accessing the RDS instance.

  5. Click OK.

  6. In the Open Connection window, select the connection task that you created just now and click Open, as shown in the following figure. If the connection information is correct, the RDS instance is connected successfully.

Thank you! We've received your feedback.