DBeaver
Learn how to use DBeaver to connect to an AnalyticDB for MySQL cluster.
Background information
DBeaver is a free, open-source universal database tool for developers and database administrators, distributed under the General Public License (GPL). It supports MySQL, PostgreSQL, Oracle, Db2, SQL Server, Sybase, and any other database that has a Java Database Connectivity (JDBC) driver. Its graphical user interface (GUI) lets you view database schemas, run SQL queries and scripts, browse and export data, manage binary large object (BLOB) and character large object (CLOB) data, and modify database structures.
Prerequisites
Ensure you meet the following prerequisites:
-
You have installed DBeaver.
-
You have installed a MySQL JDBC driver.
-
You have added the IP address of the device running DBeaver to the whitelist of your AnalyticDB for MySQL cluster. For more information, see Set a whitelist.
-
You have obtained a public endpoint for the AnalyticDB for MySQL cluster if you plan to connect over the internet. For more information, see Apply for or release a public endpoint.
Procedure
-
Start DBeaver and choose Database > New Database Connection from the main menu.
-
In the Connect to database dialog box, select MySQL as the connection type and click Next.
-
On the Connect to database page, configure the following parameters.
Parameter
Description
Server host
The endpoint of your AnalyticDB for MySQL cluster. You can find the endpoint on the Cluster Information page in the AnalyticDB for MySQL console.
Port
3306.
Database
The name of the database in your AnalyticDB for MySQL cluster.
Database Account
The user name of your database account in the AnalyticDB for MySQL cluster. The account can be a:
-
privileged account
-
standard account
Password
The password that corresponds to the user name.
-
-
After configuring the parameters, click Test Connection. If the connection is successful, click Finish to connect to the cluster.