运行node mysql报错

报错主要信息：

D:\project\express_back\node_modules\mysql\lib\protocol\Parser.js:437
      throw err; // Rethrow non-MySQL errors
      ^
Error: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
flush privileges;

解决方法：

// 进入mysql 输入密码例如：123456
mysql -u root -p 
 
// 1.执行语句 alter user 'root'@'localhost' identified with mysql_native_password by 密码;
mysql> alter user 'root'@'localhost' identified with mysql_native_password by '123456';
Query OK, 0 rows affected (0.43 sec)
 
// 2.再执行语句 flush privileges;
mysql> flush privileges;
Query OK, 0 rows affected (0.05 sec)
 
//3.成功后 退出
mysql> quit
Bye

发生原因：

MySQL8.0.4之前，MySQL的密码认证插件是
“mysql_native_password”，而以后版本使用的是“caching_sha2_password”。所以node会密码认证失败