mysql8.4.9报ERROR 1524 (HY000) at line 1: Plugin ‘mysql_native_password‘ is not loaded的解决方法

【现象】

D:\p\1\mysql-8.4.9-winx64\bin>mysql -u root --skip-password -e "ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'root'; FLUSH PRIVILEGES;"
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1524 (HY000) at line 1: Plugin 'mysql_native_password' is not loaded

【解决方法】

D:\p\1\mysql-8.4.9-winx64\bin>mysql -u root --skip-password -e "ALTER USER 'root'@'localhost' IDENTIFIED BY 'root'; FLUSH PRIVILEGES;"