2059 - Authentication plugin ‘xxxxxxx’ cannot be loaded:XXXX(无法加载身份验证插件)解决

时间:2024-03-20 18:23:37

1、打开MySQL命令行客户端,windows+r,cmd。
2、输入命令:mysql -u root -p,输入本地数据库密码。
3、输入命令:show variables like ‘default_authentication_plugin’;
4、输入命令:select host,user,plugin from mysql.user;
5、输入命令:ALTER USER ‘root’@‘localhost’ IDENTIFIED WITH mysql_native_password BY ‘root’;
2059 - Authentication plugin ‘xxxxxxx’ cannot be loaded:XXXX(无法加载身份验证插件)解决