ApsaraDB for SelectDB:Visualize data with DBeaver

Prerequisites

• Configure network access for your ApsaraDB for SelectDB instance based on your network environment:

  • If your client is on an ECS instance in the same VPC as your ApsaraDB for SelectDB instance, no additional configuration is required. You only need the VPC Endpoint of the ApsaraDB for SelectDB instance.

  • Otherwise, apply for a Apply for Public Endpoint for the ApsaraDB for SelectDB instance. For more information, see Apply for or release a public endpoint.

• Download and install the DBeaver Community client from the official DBeaver website.

  Important

  The database driver for the client must be compatible with MySQL 5.7.

• Add the client's IP address to the IP address whitelist of the ApsaraDB for SelectDB instance. For more information, see Configure an IP address whitelist.

• Obtain the username and password for the ApsaraDB for SelectDB instance.

Procedure

1. Open the DBeaver Community client.

2. Click the icon and select MySQL.

3. On the Connect to a database page, configure the connection parameters.

   The following table describes the parameters.

   Parameter	Description	Example
   Connect by	Select Host.	Host
   Server address	The endpoint of the ApsaraDB for SelectDB instance. You can obtain the VPC Endpoint (or Public Endpoint) from the Instance Details > Network Information page in the ApsaraDB for SelectDB console.	selectdb-cn-xxx-public.selectdbfe.rds.aliyuncs.com
   Port	The port number of the ApsaraDB for SelectDB instance. You can obtain the MySQL Port from the Instance Details > Network Information page in the ApsaraDB for SelectDB console.	9030
   Database	The name of the target database.	test_db
   Username	The username for the ApsaraDB for SelectDB instance.	admin
   Password	The password for the user of the ApsaraDB for SelectDB instance. If you forget the password, go to the Instance Details page and click Reset Password.	TestPassd@ Important This password is for demonstration purposes only. Do not use it in a production environment.

   For more information, see the DBeaver Community documentation.

4. Click Finish.

   A successful connection is shown below.