AnalyticDB:Navicat

Step 1: Get your cluster connection details

Before configuring Navicat, locate the following details in the AnalyticDB for MySQL console:

• Endpoint: On the Cluster Information page, copy the endpoint of the cluster.

• Port: 3306

• Database account: A privileged account or standard account for the cluster.

Step 2: Configure the connection in Navicat

1. Open Navicat for MySQL and choose File > New Connection > MySQL.

2. In the New Connection dialog box, enter the connection details:

   If you are on macOS, also enter the database name before proceeding.

   Parameter	Description
   Connection Name	A name for the connection. Use a descriptive name that identifies the cluster.
   Host	The endpoint of the AnalyticDB for MySQL cluster, copied from the Cluster Information page.
   Port	3306
   User Name	The database account name. The account can be a privileged account or a standard account.
   Password	The password of the database account.

3. Click Test Connection. After the test succeeds, click OK. The connection is created but remains disabled until you open it manually.

Step 3: Open the connection and start managing data

1. In the connection list, right-click the connection name and select Open Connection.

2. Right-click the database name and select Open Database.

The database connection is now active. Use Navicat for MySQL to query and manage data in the cluster.