Enhanced MySQL Compatibility for ClickHouse to Support mysqlsh Connection

Enhanced the MySQL compatibility to a level that now, mysqlsh (a rich MySQL CLI from Oracle) can connect to ClickHouse. This is needed to facilitate testing. #73912 (Alexey Milovidov).