登录远程登录mysql报错：ERROR 2059 (HY000): Authentication plugin 'caching_sha2_password' cannot be loaded: /usr/lib64/mysql/plugin/caching_sha2_password.so: cannot open shared object file: No such file or directory

执行：ALTER USER '$USER'@'%' IDENTIFIED WITH mysql_native_password BY '$MYPassword';

执行：FLUSH PRIVILEGES;

远程连接测试：