This topic describes how to connect to an ApsaraDB for SelectDB instance using Navicat. This allows you to visually manage your database more conveniently and efficiently.
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.
ImportantThe 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.
Procedure
-
Open Navicat Premium.
-
Click Connection, and then select MySQL.
-
In the New Connection window, configure the connection parameters.
The following table describes the connection parameters.
Parameter
Description
Example
Connection Name
A custom name for the connection.
test
Host
The endpoint of your ApsaraDB for SelectDB instance. This endpoint is available on the instance details page.
selectdb-cn-****.selectdbfe.rds.aliyuncs.com
Port
The port for your ApsaraDB for SelectDB instance. This port can be found in the MySQL Port field on the instance details page.
9030
User Name
The ApsaraDB for SelectDB for the ApsaraDB for SelectDB instance. This value is always admin.
admin
Password
The ApsaraDB for SelectDB for the instance's database account.
If you forget the password, use the Reset Password option on the instance details page.
TestPassd@
ImportantThis password is for demonstration purposes only. Do not use it in a production environment.
-
Click Save.
The following figure shows a successful connection.