v.19.8New Features

Added Server Which Allows Connecting to Clickhouse Using Mysql Client

Added server which allows connecting to ClickHouse using MySQL client. #4715 (Yuriy Baranov)
Added a server feature that allows connecting to ClickHouse using the MySQL client.

Why it matters

This feature enables users to interact with ClickHouse through the familiar MySQL client interface, facilitating integration with existing tools and workflows that support MySQL protocol. It solves the problem of incompatibility between ClickHouse and MySQL clients by providing native protocol support.

How to use it

Run the ClickHouse server with the MySQL protocol enabled (usually via configuration or startup parameters). Then connect using any MySQL client by specifying the ClickHouse server as the host and using the appropriate credentials and port.