Authentication plugin ‘caching_sha2_password‘ cannot be loaded问题

mysql -u root -p

ALTER USER 'root'@'localhost' IDENTIFIED BY 'password' PASSWORD EXPIRE NEVER;

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';


FLUSH PRIVILEGES;


alter user 'root'@'localhost' identified by 'root';