Add Database Engine Mysql That Allow to View All the Tables in Remote Mysql Server #5599 (winter Zhang)

Why it matters

This feature allows users to seamlessly integrate data from a MySQL server with ClickHouse, enabling unified querying and analysis without data duplication or migration. It solves the problem of cross-database data access by providing direct visibility of MySQL tables within ClickHouse.

How to use it

To use this feature, create a database in ClickHouse using the MySQL engine and specify connection parameters such as host, port, username, and password to connect to the remote MySQL server. For example:

CREATE DATABASE mysql_database ENGINE = MySQL('host:port', 'database_name', 'user', 'password');

After creation, all tables in the specified MySQL database will be accessible within ClickHouse under the created database namespace.