mysqldump: Got error: 2059: Authentication plugin 'mysql_native_password' cannot be loaded: dlopen(/opt/homebrew/Cellar/mysql/9.0.1_4/lib/plugin/mysql_native_password.so, 0x0002): tried: '/opt/homebrew/Cellar/mysql/9.0.1_4/lib/plugin/mysql_native_password.so' (no such file), '/System/Volumes/Preboot/Cryptexes/OS/opt/homebrew/Cellar/mysql/9.0.1_4/lib/plugin/mysql_native_password.so' (no such file), '/opt/homebrew/Cellar/mysql/9.0.1_4/lib/plugin/mysql_native_password.so' (no such file) when trying to connect
ALTER USER 'root2'@'%' IDENTIFIED WITH 'mysql_native_password' BY 'root2123456';
FLUSH PRIVILEGES;