I recently baught a new laptop and while setting up my dev environment I found that I was getting the error
SequelPro MySQL said: Authentication plugin 'caching_sha2_password' cannot be loaded: dlopen(/usr/local/lib/plugin/caching_sha2_password.so, 2): image not found.
I had insalled MySQL through Brew and i was able to run
mysql_secure_installation in terminal.
Once I had secured the install, I loged into MySQL through the terminalt make sure i can access it.
mysql -u root -p.
One i was in I was able run
ALTER USER root@localhost IDENTIFIED WITH mysql_native_password BY 'your_password';
which alters the root user and changes the default password authentication to MySQLs native password.
Once updated I was able to access SequelPro without the error popping up.