今天用npm执行mysql的时候报了一个错误。具体sql错误信息是:
Client does not support authentication protocol requested by server; consider upgrading MySQL client
解决办法是在mysql里面,你要查询的数据库上执行下面的指令
USE mysql;
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';
FLUSH PRIVILEGES;
root是用户名,localhost是ip地址127.0.0.1都是特指本机,mysql_native_password是旧的密码验证机制,password是密码,最后别忘了分号;
最后问题解决:
同时感谢https://blog.csdn.net/u013700358/article/details/80306560的方案