Connect Navicat to a SelectDB instance - ApsaraDB for SelectDB

Connect to an ApsaraDB for SelectDB instance by using Navicat to visually manage your database with greater efficiency.

Prerequisites

Configure the network for your ApsaraDB for SelectDB instance based on your client's network environment:
- If your client runs on an ApsaraDB for SelectDB instance in the same Virtual Private Cloud (VPC) as your ApsaraDB for SelectDB instance, no network configuration is required. You only need the VPC Endpoint of the ApsaraDB for SelectDB instance.
- In other cases, you must Apply for Public Endpoint for your ApsaraDB for SelectDB instance. For details, see Apply for or release a public endpoint.
You have downloaded and installed the Navicat Premium client from the Navicat official website.

Important
The client's database connector must be compatible with MySQL 5.7.
You have added your client's IP address to the ApsaraDB for SelectDB for your ApsaraDB for SelectDB instance. For details, see Configure an IP address whitelist.
You have the ApsaraDB for SelectDB and password for your ApsaraDB for SelectDB instance.

In the New Connection window, configure the connection parameters.

The following table describes the parameters.

Parameter	Description	Example
Connection Name	A custom name for the connection.	test
Host	The endpoint of your ApsaraDB for SelectDB instance, available on the instance details page.	selectdb-cn-****.selectdbfe.rds.aliyuncs.com
Port	The port of your ApsaraDB for SelectDB instance, shown in the MySQL Port field on the instance details page.	9030
User Name	The username of the ApsaraDB for SelectDB instance. This value is always admin.	admin
Password	The password of the database account for your ApsaraDB for SelectDB instance. If you forget the password, use the Reset Password option on the instance details page.	TestPassd@ Important This password is for demonstration purposes only. Do not use it in a production environment.