v.20.3Improvement
Enabled MySQL Compatibility Server on Port 9004 and Fixed Password Generation Command
Enabled MySQL compatibility server on port 9004 in the default server configuration file. Fixed password generation command in the example in configuration. #8771 (Yuriy Baranov)Why it matters
This feature allows ClickHouse to accept connections using the MySQL protocol by default, enhancing interoperability with tools and applications that support MySQL. It simplifies integration by eliminating the need for manual configuration to enable MySQL compatibility.How to use it
Start the ClickHouse server with the default configuration. The MySQL compatibility server will automatically listen on port9004. Connect to ClickHouse using MySQL-compatible clients by specifying the port 9004.