Skip to main content

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:

mysql>
create user user1 identified by 'abc123';

Grant privileges for the user:

mysql>
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
  1. Query Data