nodejs连接mysql报错throw err;Rethrow non-MySQL errors解决方法

环境：mysql: 8.0+ ；win10； 64位；

报错主要信息：

D:\projects\nodejs\blog-1\node_modules\_mysql@2.17.1@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

nodejs环境重启下即可 npm run dev