登录错误 ERROR 1524 (HY000): Plugin 'mysql_native_plugin' is not loaded

mysql -uroot -proot

执行

use mysql;
ALTER USER 'root'@'localhost' IDENTIFIED WITH caching_sha2_password BY 'root';

跳过权限

mysqld --skip-grant-tables --skip-networking

use mysql;
ALTER USER 'root'@'localhost' IDENTIFIED WITH caching_sha2_password BY 'root';

或者

use mysql;
UPDATE user SET plugin='caching_sha2_password' WHERE user='root' AND host='localhost';
FLUSH PRIVILEGES;