All Products
Search
Document Center

DBeaver

Last Updated: May 13, 2019

This topic describes how to connect to DLA by using DBeaver.

Prerequisites

You have completed the following steps:

  • Install DBeaver.

  • Install the MySQL JDBC driver.

Procedure

  1. Start DBeaver and choose Database > New Connection from the main menu.

  2. In the Connect to database wizard that appears, select MySQL as the connection type, and click Next.

  3. On the Connection Settings page of the Connect to database wizard, set the parameters as required.

    1

    The following table describes the parameters.

    Parameter Description
    Server Host The host IP address that is used to connect to DLA.
    • If DBeaver is installed on an ECS instance that is in the same region as DLA, specify a VPC address for DLA access in this field. Then, DBeaver connects to DLA through the VPC, which is faster and safer.
    • If DBeaver needs to connect to DLA through the Internet, specify a classic network address for DLA access in this field.
    Port The port number of the host. Set it to 10000.
    User name The root account or sub-account for DLA access.
    Password The password of the account for DLA access.
  4. After you configure the preceding parameters, click Test Connection…. After the test succeeds, click Finish. A connection to DLA has been established but is inactive. Activate the connection manually.

  5. Right-click the connection name and choose Connect from the shortcut menu to activate the DLA connection. Then, you can use DBeaver to manage data in DLA.