mysql 8 Authentication error

[abostroem]

It was reported that in mysql 8, the current database gives the following error:
Error 2059: Authentication plugin 'caching_sha2_password' cannot be loaded: /home/anjasha/anaconda3/envs/lcogtsnpipe/lib/plugin/caching_sha2_password.so: cannot open shared object file: No such file or directory

And that this error can be fixed with the following mysql command:
ALTER USER 'supernova'@'localhost' IDENTIFIED with mysql_native_password by ;