This topic describes how to use DBeaver to connect to an AnalyticDB for MySQL cluster.

Background information

DBeaver is a free and open source database management tool distributed under General Public License (GPL). It is designed for developers and database administrators. DBeaver supports databases that are compatible with Java Database Connectivity (JDBC), such as MySQL, PostgreSQL, Oracle, Db2, SQL Server, and Sybase. DBeaver provides a graphical user interface (GUI), on which you can view database schemas, execute SQL statements and scripts, view and export data, and process binary large object (BLOB) or character large object (CLOB) data.

Prerequisites

Before you use DBeaver, make sure that the following requirements are met:

  • DBeaver is installed.
  • MySQL JDBC is installed.
  • The IP address of the device on which DBeaver is installed is added to the whitelist of the AnalyticDB for MySQL cluster. For more information, see Configure a whitelist.
  • A public endpoint is obtained for the AnalyticDB for MySQL cluster if you want to connect to the cluster over the Internet. For more information, see Apply for or release a public endpoint.

Procedure

  1. Start DBeaver and choose Database > New Database Connection.
  2. In the Connect to database dialog box, select MySQL for the connection type and click Next.
  3. In the Connect to database dialog box, configure the parameters described in the following table.
    Parameter Description
    Server Host

    The endpoint used to connect to the AnalyticDB for MySQL cluster. You can view the connection information about the cluster on the Cluster Information page of the AnalyticDB for MySQL console.

    Port The port number used to connect to the AnalyticDB for MySQL cluster. The default port number is 3306.
    Database

    The name of the database in the AnalyticDB for MySQL cluster.

    User name
    The name of the account used to connect to the AnalyticDB for MySQL cluster. You can use one of the following account types:
    • Privileged account
    • Standard account
    Password

    The password of the account used to connect to the AnalyticDB for MySQL cluster.

  4. After you configure the preceding parameters, click Test Connection. After the connection passes the test, click Finish to connect to the cluster.