Skip to main content

MySQL-Compatible Clients

Databend provides support for MySQL compatible CLI and GUI clients where you can connect to Databend and execute queries from.

note

Databend is not a complete implementation of the MySQL protocol, so certain programs such as some ORM frameworks may not be able to connect to Databend.

To connect to Databend with MySQL compatible clients, you will need to connect to port 3307 with a SQL user created in Databend.

This example connects to a remote Databend with a SQL user named databend:

mysql -h172.20.0.2 -udatabend -P3307 -pdatabend

This example connects to a local Databend with the user root:

mysql -h127.0.0.1 -uroot -P3307 

Related video:

Example: Connect from 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.

The following steps show how to establish a connection to Databend with DBeaver.

  1. Create a SQL user in Databend.
CREATE USER user1 IDENTIFIED BY 'abc123';
GRANT ALL ON *.* TO user1;
  1. In DBeaver, choose a driver for the new connection. Select MySQL, then click Next.

  1. On the Connection Settings screen, configure your connection settings, including:
  • Host
  • Port
  • Database name
  • Username and password

  1. Click Test Connection... to see if the connection works.