Plugin caching_sha2_password could not be loaded: Error loading shared library

I've tried some of the fixes on the internet like this one

ALTER USER "user" IDENTIFIED WITH mysql_native_password BY 'foobar';

But still coming up against it