Better MySQL client compatibility without sha2_password auth plugin

Why it matters

This feature addresses the issue where some MySQL clients cannot connect to ClickHouse due to lack of support for the sha2_password auth plugin, enabling a broader range of clients to access ClickHouse without authentication errors.

How to use it

Users can leverage this compatibility enhancement by connecting with MySQL clients that do not support the sha2_password authentication plugin; no special configuration is required on ClickHouse as the compatibility support is built-in.