Connect to the streaming engine using the MySQL command line - Lindorm

The Lindorm streaming engine supports SQL access over the MySQL protocol. This topic describes how to connect to it using the MySQL client.

Prerequisites

Before you begin, make sure you have:

Enabled the streaming engine
Added the client's IP address to the Lindorm whitelist

Install the MySQL client

Install MySQL client 8.0 or later.

Linux (APT)
```
sudo apt-get install mysql-client
```
Linux (Yum)
```
sudo yum install mysql
```
macOS
```
brew install mysql-client
```
Windows Download and run the installer from MySQL Command-Line Client.

Get the endpoint

Log on to the Lindorm console. In the upper-left corner, select the region of your instance. On the Instances page, click the instance ID or click View Instance Details in the Actions column.
In the left navigation pane, choose Database Connections.
Click the Stream Engine tab and copy the Lindorm streaming engine SQL address. The address format is <host>:<port>. Strip the colon and port number to get the MySQL URL — for example, ld-bp1mq0tdzbx1m****-proxy-stream-vpc.lindorm.aliyuncs.com.

Important
Currently, only virtual private cloud (VPC) endpoints are supported.

Connect to the streaming engine

Run the following command to connect:

# Replace the placeholders with your actual values:
#   <mysql_url>  — the MySQL URL from the Stream Engine tab (host only, no port)
#   <username>   — the username from the Stream Engine tab
#   <password>   — the password from the Stream Engine tab
mysql -h <mysql_url> -P 33060 -u <username> -p<password>

Example:

mysql -h ld-bp1mq0tdzbx1m****-proxy-stream-vpc.lindorm.aliyuncs.com -P 33060 -utest -ptest

What's next

Quick Start: Real-time ETL — Use ETL SQL to run real-time pre-computation at the table level.
Stream Job O&M Platform — Submit and manage JAR, SQL, and Python stream jobs.