Connecting Databend with DBeaver

What is DBeaver?

DBeaver is a universal database management tool for everyone who needs to work with data in a professional way. With DBeaver you are able to manipulate with your data like in a regular spreadsheet, create analytical reports based on records from different data storages, export information in an appropriate format.

-- From About DBeaver

DBeaver

Create a Databend User

Connect to Databend server with MySQL client:

mysql -h127.0.0.1 -uroot -P3307 

Create a user:

CREATE USER user1 IDENTIFIED BY 'abc123';

Grant privileges for the user:

GRANT ALL ON *.* TO user1;

See also How To Create User.

Install DBeaver

Please refer DBeaver Installation

Create DBeaver Connection

1. Choose a driver for the new connection: click the MySQL type in the gallery, then click Next.

   

2. In the Connection Settings screen, on the General tab, set the primary connection settings:

   

For most drivers required settings include:

• Host
• Port
• Database name
• Username and password

3. Query Data