Added Mysql_native_password Authentication Plugin to Mysql Compatibility Server

Why it matters

This feature enables ClickHouse's MySQL compatibility server to authenticate clients using the widely adopted mysql_native_password plugin, improving compatibility with MySQL clients and tools that rely on this authentication method.

How to use it

To use this feature, connect to the ClickHouse MySQL compatibility server with clients configured to use the mysql_native_password authentication plugin. No additional configuration is needed on the ClickHouse side as this plugin is now supported by default.