All Products
Search

This Product

    AnalyticDB:Navicat

    Document Center

    AnalyticDB:Navicat

    Last Updated:Oct 28, 2024

    Navicat is a fast, reliable, and cost-effective database management tool designed to simplify database management and reduce costs. Navicat provides a GUI for you to create connections from your on-premises device to AnalyticDB for MySQL clusters and manage data in a convenient manner.

    Prerequisites

    Before you use Navicat, make sure that the following requirements are met:

    • You are familiar with the compatibility between Navicat and AnalyticDB for MySQL. For more information, see Compatibility overview.

    • Navicat is installed. We recommend that you install V16.0.14 or later of Navicat Premium or Navicat for MySQL. In this example, Navicat for MySQL is used.

    • The IP address of the device on which Navicat is installed is added to an IP address whitelist of the AnalyticDB for MySQL cluster to which you want to connect. For more information, see Configure an IP address whitelist.

    • A public endpoint is obtained if you want to connect to the AnalyticDB for MySQL cluster over the Internet. For more information, see Apply for or release a public endpoint.

    Procedure

    1. Start Navicat for MySQL and choose File > New Connection > MySQL. In the New Connection dialog box, configure the parameters that are described in the following table.

      Parameter

      Description

      Connection Name

      The name of the connection. We recommend that you set a descriptive name that makes it easy to identify.

      Host

      The endpoint that is used to connect to the AnalyticDB for MySQL cluster. You can obtain the endpoint on the Cluster Information page of the AnalyticDB for MySQL console.

      Port

      The port number that is used to connect to the AnalyticDB for MySQL cluster. Set the value to 3306.

      User Name

      The name of the database account that is used to connect to the AnalyticDB for MySQL cluster. The database account can be one of the following types:

      • Privileged account.

      • Standard account.

      Password

      The password of the database account that is used to connect to the AnalyticDB for MySQL cluster.

      If your operating system is macOS, add the database name after you configure the connection information.

    2. Click Test Connection. After the test succeeds, click OK. The connection to the AnalyticDB for MySQL cluster is created but is disabled. You must manually enable the connection.

    3. Right-click the connection name of the created connection and select Open Connection. Right-click a database name and select Open Database to enable the database connection. Then, you can use Navicat for MySQL to manage data.