search

apecloud / myduckserver

MySQL & Postgres Analytics, Reimagined
184 stars 8 forks source link

MySQL 9.* client on macOS is not supported #137

Open fanyang01 opened 1 week ago

fanyang01 commented 1 week ago 
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 commented 3 days ago

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 commented 3 days ago

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