Connect to EMQX Tables Using DBeaver

DBeaver is a free, open-source, cross-platform database management tool that supports a wide range of databases. Its intuitive interface and rich feature set make it a popular choice for developers, analysts, and database administrators.

You can use DBeaver to connect to EMQX Tables via MySQL database drivers.

Steps to Connect

1. Open DBeaver and click New Database Connection from the toolbar.

2. In the connection wizard, select MySQL(Old) and click Next.

   • If prompted, install the MySQL driver.

3. In the Connection Settings, select Connect by: Host, and enter the following details:

   You can find the host, database name, and port on the EMQX Tables Deployment Overview page. Create or manage the username and password in User Management.

   • Host: {YOUR_EMQX_TABLES_PUBLIC_HOST}
   • Port: 4002
   • Database: {YOUR_EMQX_TABLES_DB_NAME}
   • Username: {YOUR_EMQX_TABLES_USERNAME}
   • Password: {YOUR_EMQX_TABLES_PASSWORD}

4. Click Test Connection to verify the setup.

5. If successful, click Finish to save and create the connection.

Note: EMQX Tables supports encrypted connections by default (TLS). Ensure your MySQL driver in DBeaver supports SSL if required.