All Products
Search
Document Center

ApsaraDB RDS:How do I connect to an ApsaraDB RDS instance such as ApsaraDB RDS for MySQL instance by using Navicat?

Last Updated:Dec 22, 2023

This topic describes how to use Navicat to connect to an RDS instance that runs MySQL, SQL Server, PostgreSQL, or MariaDB. Navicat is a third-party database management tool.

Note

Alibaba Cloud has officially launched Data Management (DMS), which provides the graphical data management feature. This feature is used to manage relational databases and NoSQL databases, and supports capabilities such as data management, schema management, user authorization, security audit, data trend analysis, data tracking, BI charts, and performance and optimization.

We recommend that you use DMS to manage your databases. For more information about how to use DMS to connect to an RDS instance, see Use DMS to log on to an ApsaraDB RDS for MySQL instance.

Prerequisites

The following requirements are met:

Procedure

  1. Start the Navicat client.

  2. In the upper-left corner, click Connection and select the type of the database to be connected.

    Note

    If your Navicat client has not been upgraded to the latest version, the Alibaba Cloud menu is not displayed. You can select a database type such as MySQL or PostgreSQL.

    创建连接

  3. Enter the information about the RDS instance to which you want to connect. The following table describes the required parameters.

    连接设置

    Parameter

    Description

    Connection Name

    Enter a custom name of the connection.

    Host

    Enter the internal or public endpoint of the RDS instance. The following list describes the internal and public endpoints:

    • If your client is deployed on an Elastic Compute Service (ECS) instance that resides in the same region and has the same network type as the RDS instance, use the internal endpoint. For example, if the ECS and RDS instances are both in a VPC located in the China (Hangzhou) region, you can use the internal endpoint of the RDS instance to create a secure connection.

    • In other situations, use the public endpoint.

    For more information about how to view the internal and public endpoints and port numbers of an RDS instance, see View and manage instance endpoints and ports.

    Port

    If you want to connect to the RDS instance over the internal network, enter the internal port of the RDS instance. If you want to connect to the RDS instance over the public network, enter the public port of the instance.

    Username

    Enter the username of the account that is used to connect to the RDS instance.

    Password

    The password of the account that is used to connect to the RDS instance.

  4. Click OK.

    Note

    If you fail to connect to the RDS instance, troubleshoot the issue. For more information, see What do I do if I fail to connect to an ApsaraDB RDS instance?

    连接成功

FAQ

For more information about how to troubleshoot the issue that you cannot connect to an RDS instance, see What do I do if I fail to connect to an ApsaraDB RDS instance?