All Products
Search

This Product

    ApsaraDB for SelectDB:Use Navicat to visualize data

    Document Center

    ApsaraDB for SelectDB:Use Navicat to visualize data

    Last Updated:Jan 03, 2025

    You can use Navicat to efficiently manage ApsaraDB for SelectDB data in a visualized manner. This topic describes how to connect to an ApsaraDB for SelectDB instance by using Navicat. This makes database management easier and more efficient.

    Prerequisites

    • The network settings of the ApsaraDB for SelectDB instance to which you want to connect are configured based on the network environment of the Navicat client:

      • If the Navicat client is deployed on an Elastic Compute Service (ECS) instance and resides in the same virtual private cloud (VPC) as the ApsaraDB for SelectDB instance, you do not need to configure the network settings of the ApsaraDB for SelectDB instance. You need to only obtain the VPC endpoint of the ApsaraDB for SelectDB instance.

      • In other cases, you must apply for a public endpoint for the ApsaraDB for SelectDB instance. For more information, see Apply for or release a public endpoint.

    • The Navicat Premium client is downloaded and installed. To download the Navicat Premium client, go to the Navicat official website.

      Important

      The database connector of the MySQL client is compatible with MySQL 5.7.

    • The IP address of the server on which the Navicat client is deployed is added to an IP address whitelist of the ApsaraDB for SelectDB instance. For more information, see Configure an IP address whitelist.

    • The database account and password of the ApsaraDB for SelectDB instance are obtained.

    Procedure

    1. Open the Navicat Premium client.

    2. In the top navigation bar, choose Connection > MySQL.

    3. In the New Connection (MySQL) dialog box, configure the parameters for connection.

      The following table describes the parameters.

      Parameter

      Description

      Example

      Connection Name

      The name that is used to identify a connection. You can specify a name.

      test

      Host

      The endpoint of the ApsaraDB for SelectDB instance. You can view the endpoint on the details page of the ApsaraDB for SelectDB instance.

      selectdb-cn-****.selectdbfe.rds.aliyuncs.com

      Port

      The port number used to connect to the ApsaraDB for SelectDB instance. You can view the port number in the MySQL Port field on the details page of the ApsaraDB for SelectDB instance.

      9030

      User Name

      The database account of the ApsaraDB for SelectDB instance. Set this parameter to admin.

      admin

      Password

      The password of the database account.ApsaraDB for SelectDB

      If you forget the password, go to the details page of the ApsaraDB for SelectDB instance and click Reset Password.

      TestPassd@

      Important

      This example is for reference only. Do not use it in actual business scenarios.

    4. Click OK.