Barnyard 2 mysql login failure

[edr]

When I try to connect my Barnyard2 service to mysql I get the following error:

database mysql_error: Authentication plugin 'caching_sha2_password' cannot be loaded: Cannot open "/usr/local/lib/mysql/plugin/caching_sha2_password.so"

Any help would be appreciated!