ApsaraDB for SelectDB:Use Navicat to visualize data

Prerequisites

Before you begin, make sure you have:

• Network access configured based on where the Navicat client is deployed:

  • If the Navicat client runs on an Elastic Compute Service (ECS) instance in the same virtual private cloud (VPC) as your SelectDB instance, obtain the VPC endpoint from the instance details page. No additional network configuration is required.

  • In all other cases, apply for a public endpoint for your SelectDB instance. For details, see Apply for or release a public endpoint.

• Navicat Premium installed. Download it from the Navicat official website.

  Important

  The MySQL client connector is compatible with MySQL 5.7.

• The Navicat client's IP address added to an IP address whitelist of the SelectDB instance. For details, see Configure an IP address whitelist.

• The database account and password for your SelectDB instance.

Connect to an ApsaraDB for SelectDB instance

1. Open Navicat Premium.

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

3. In the New Connection (MySQL)

   • Connection Name: A name to identify this connection. For example, test.

   • Host: The endpoint of your SelectDB instance. Find this on the instance details page. For example, selectdb-cn-****.selectdbfe.rds.aliyuncs.com.

   • Port: The port number. Find this in the MySQL Port field on the instance details page. The default port is 9030.

   • User Name: The database account. Set this to admin.

   • Password: The password for the database account. To reset a forgotten password, go to the instance details page and click Reset Password.

     Important

     The password TestPassd@ is shown as an example only. Do not use it in production.

4. Click OK to save the connection.