MySQL 9.* client on macOS is not supported

[fanyang01]

mysql -h 127.0.0.1 -P 3306 -u root 
ERROR 2059 (HY000): Authentication plugin 'mysql_native_password' cannot be loaded: dlopen(/opt/homebrew/Cellar/mysql-client/9.0.1/lib/plugin/mysql_native_password.so, 0x0002): tried: '/opt/homebrew/Cellar/mysql-client/9.0.1/lib/plugin/mysql_native_password.so' (no such file), '/System/Volumes/Preboot/Cryptexes/OS/opt/homebrew/Cellar/mysql-client/9.0.1/lib/plugin/mysql_native_password.so' (no such file), '/opt/homebrew/Cellar/mysql-client/9.0.1/lib/plugin/mysql_native_password.so' (no such file)

[NoyException]

I've tried it on MySQL 9.1.0 client but this bug didn't occur.

(base) noy@Noy:~/downloads$ mysql --version
mysql  Ver 9.1.0 for Linux on x86_64 (MySQL Community Server - GPL)
(base) noy@Noy:~/downloads$ mysql -h 127.0.0.1 -P 3306 -u root 
Welcome to the MySQL monitor.  Commands end with ; or \g.

[fanyang01]

@NoyException Thanks for checking this on Linux. It appears to be a macOS-specific problem.