Sequel Pro - MySQL said: Authentication plugin 'caching_sha2_password' cannot be loaded: dlopen(/usr/local/lib/plugin/caching_sha2_password.so, 2): image not found under MacOS

I have found the solution. The MySQL 8.0 that I use, requires some additional configurations.

Steps:

1. I have logged as root user into MySQL console using the MacOS terminal:

xxxxxxxxxx

/usr/local/mysql-8.0.27-macos11-x86_64/bin/mysql -u root -p

2. I have added permissions by executing (optional step):

xxxxxxxxxx

GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost';

3. I have updated the password by executing:

xxxxxxxxxx

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'root_password_here';

4. to exit MySQL console:

xxxxxxxxxx

exit