MySQL 连接出现 Authentication plugin ‘caching_sha2_password‘ cannot be loaded

use mysql;

select user,host from user;

ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '123';