Use DBeaver to query and manage your AnalyticDB for MySQL cluster through a graphical interface.
Background information
DBeaver is a free and open source database management tool distributed under General Public License (GPL). 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) that lets you 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 begin, make sure you have:
DBeaver installed. Download from dbeaver.io.
MySQL JDBC installed.
The IP address of your DBeaver machine added to the cluster whitelist. See Configure a whitelist.
A public endpoint for the cluster, if connecting over the Internet. See Apply for or release a public endpoint.
Connect to the cluster
Start DBeaver and choose Database > New Database Connection.
In the Connect to database dialog, select MySQL and click Next.
Configure the connection parameters.
If DBeaver prompts you to download driver files, click Download to install the MySQL Java Database Connectivity (JDBC) driver automatically.
Parameter Description Server Host The cluster endpoint. Find it on the Cluster Information page of the AnalyticDB for MySQL console. Port The port number. The default is 3306.Database The name of the database in the cluster. User name The account name. Use a privileged account or a standard account. Password The account password. Click Test Connection. After the test passes, click Finish.
What's next
Query and manage your data using the DBeaver SQL editor. See the DBeaver documentation.
Create databases and accounts for your cluster in the AnalyticDB for MySQL console.