MaterializedMySQL won't start with MySQL8.4

[Slach]

Describe what's wrong

Recently released MySQL 8.4
remove --default-authentication-plugin=mysql_native_password
and replace it to
--mysql-native-password=ON

A link to reproducer

https://gist.github.com/Slach/1db8f5ec1df586f5f6427b0188977fdd

Does it reproduce on the most recent release?
Yes, it reproduce on head and latest docker images (24.4,24.5)

How to reproduce

git clone https://gist.github.com/Slach/1db8f5ec1df586f5f6427b0188977fdd ./mysql84_materialized_mysql
cd ./mysql84_materialized_mysql
bash -xe ./reproduce.sh
docker-compose exec clickhouse tail -n 100 /var/log/clickhouse-server/clickhouse-server.err.log

Expected behavior
Successful start MaterializedMySQL

Error message and/or stacktrace

2024.05.02 10:06:28.851189 [ 48 ] {2eb2c123-b147-4e67-a30d-7279d059e23a} <Error> TCPHandler: Code: 695. DB::Exception: Load job 'startup MaterializedMySQL database mysql' failed: Code: 537. DB::Exception: Illegal MySQL variables, the MaterializedMySQL engine requires default_authentication_plugin='mysql_native_password'. (ILLEGAL_MYSQL_VARIABLE), Stack trace (when copying this message, always include the lines below):

0. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000c9b62fb
1. DB::Exception::Exception(PreformattedMessage&&, int) @ 0x00000000078128ec
2. DB::Exception::Exception<String&>(int, FormatStringHelperImpl<std::type_identity<String&>::type>, String&) @ 0x000000000782d3eb
3. DB::checkMySQLVariables(mysqlxx::Pool::Entry const&, DB::Settings const&) @ 0x000000001017d8c1
4. DB::MaterializedMySQLSyncThread::assertMySQLAvailable() @ 0x000000001017c0e9
5. void std::__function::__policy_invoker<void (DB::AsyncLoader&, std::shared_ptr<DB::LoadJob> const&)>::__call_impl<std::__function::__default_alloc_func<DB::DatabaseMaterializedMySQL::startupDatabaseAsync(DB::AsyncLoader&, std::unordered_set<std::shared_ptr<DB::LoadJob>, std::hash<std::shared_ptr<DB::LoadJob>>, std::equal_to<std::shared_ptr<DB::LoadJob>>, std::allocator<std::shared_ptr<DB::LoadJob>>>, DB::LoadingStrictnessLevel)::$_0, void (DB::AsyncLoader&, std::shared_ptr<DB::LoadJob> const&)>>(std::__function::__policy_storage const*, DB::AsyncLoader&, std::shared_ptr<DB::LoadJob> const&) @ 0x0000000010140ca3
6. void std::__function::__policy_invoker<void ()>::__call_impl<std::__function::__default_alloc_func<DB::AsyncLoader::spawn(DB::AsyncLoader::Pool&, std::unique_lock<std::mutex>&)::$_0, void ()>>(std::__function::__policy_storage const*) @ 0x000000000cbb1106
7. ThreadPoolImpl<ThreadFromGlobalPoolImpl<false, true>>::worker(std::__list_iterator<ThreadFromGlobalPoolImpl<false, true>, void*>) @ 0x000000000ca6d919
8. void std::__function::__policy_invoker<void ()>::__call_impl<std::__function::__default_alloc_func<ThreadFromGlobalPoolImpl<false, true>::ThreadFromGlobalPoolImpl<void ThreadPoolImpl<ThreadFromGlobalPoolImpl<false, true>>::scheduleImpl<void>(std::function<void ()>, Priority, std::optional<unsigned long>, bool)::'lambda0'()>(void&&)::'lambda'(), void ()>>(std::__function::__policy_storage const*) @ 0x000000000ca7168a
9. void* std::__thread_proxy[abi:v15000]<std::tuple<std::unique_ptr<std::__thread_struct, std::default_delete<std::__thread_struct>>, void ThreadPoolImpl<std::thread>::scheduleImpl<void>(std::function<void ()>, Priority, std::optional<unsigned long>, bool)::'lambda0'()>>(void*) @ 0x000000000ca7048d

Additional context

Will try to prepare PR soon