mysql_native_password cannot be loaded en utilisant mysqldump

Clairement juste pour m’en rappeler. Mais si jamais ça peut aider quelqu’un ;).

Je tentais de rouler mysqldump ce matin et j’ai obtenu l’erreur suivante:

mysqldump: Got error: 2059: Authentication plugin ‘mysql_native_password’ cannot be loaded: dlopen(/usr/local/Cellar/mysql-client/9.0.1/lib/plugin/mysql_native_password.so, 0x0002): tried: ‘/usr/local/Cellar/mysql-client/9.0.1/lib/plugin/mysql_native_password.so’ (no such file), ‘/System/Volumes/Preboot/Cryptexes/OS/usr/local/Cellar/mysql-client/9.0.1/lib/plugin/mysql_native_password.so’ (no such file), ‘/usr/local/Cellar/mysql-client/9.0.1/lib/plugin/mysql_native_password.so’ (no such file) when trying to connect

Après quelques recherches, je suis tombé sur Homebrew MySQL brew upgrade broke mysql – MacOS Sonoma 14.5 (merci Jean-Philippe Lemelin :)).

J’avais effectivement roulé un brew upgrade récemment.

Donc, downgrader mysql-client à la version 8.4.

brew uninstall mysql-client
brew install [email protected]

Ajouter au system path:

export PATH=${PATH}:/usr/local/Cellar/[email protected]/8.4.2/bin

Et voilà!