All Products
Search

This Product

    ApsaraDB for SelectDB:Use DBeaver to visualize data

    Document Center

    ApsaraDB for SelectDB:Use DBeaver to visualize data

    Last Updated:Mar 27, 2025

    You can use DBeaver to efficiently manage ApsaraDB for SelectDB data in a visualized manner. This topic describes how to connect to an ApsaraDB for SelectDB instance by using DBeaver. This makes database management easier and more efficient.

    Prerequisites

    • The network of the ApsaraDB for SelectDB instance to which you want to connect is configured based on the network environment of the DBeaver client.

      • If the DBeaver client is deployed on an Elastic Compute Service (ECS) instance and is in the same virtual private cloud (VPC) as the ApsaraDB for SelectDB instance, you do not need to configure the network of the ApsaraDB for SelectDB instance. You need to obtain only the VPC endpoint of the ApsaraDB for SelectDB instance.

      • In other cases, apply for a public endpoint for the ApsaraDB for SelectDB instance. For more information, see Apply for or release a public endpoint.

    • The DBeaver Community client is downloaded and installed. To download the DBeaver Community client, go to the DBeaver official website.

      Important

      The database connector of the client must be compatible with MySQL 5.7.

    • The IP address of the server on which the DBeaver client is deployed is added to the IP address whitelist of the ApsaraDB for SelectDB instance. For more information, see Configure an IP address whitelist.

    • The username and password that are used to log on to the ApsaraDB for SelectDB instance are obtained.

    Procedure

    1. Open the DBeaver Community client.

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

    3. In the Connect to a database dialog box, configure the parameters for connection.

      The following table describes the parameters.

      Parameter

      Description

      Example

      Connect by

      The connection method. Select Host.

      Server Host

      Server Address

      The endpoint of the ApsaraDB for SelectDB instance. You can view the VPC endpoint or public endpoint of the ApsaraDB for SelectDB instance in the Network Information section of the Instance Details page of the instance.

      selectdb-cn-xxx-public.selectdbfe.rds.aliyuncs.com

      Port

      The port number that is used to connect to the ApsaraDB for SelectDB instance. You can view the MySQL port number of the ApsaraDB for SelectDB instance in the Network Information section of the Instance Details page of the instance.

      9030

      Database

      The name of the database to which you want to connect.

      test_db

      Username

      The username that is used to log on to the ApsaraDB for SelectDB instance.

      admin

      Password

      The password that is used to log on to the ApsaraDB for SelectDB instance.

      If you forget the password, go to the Instance Details page of the ApsaraDB for SelectDB instance and click Reset Password.

      TestPassd@

      Important

      This example is for reference only. Do not use it in actual business scenarios.

      For more information about the parameters, see DBeaver Community.

    4. Click Finish.