node连接mysql报错：ER_NOT_SUPPORTED_AUTH_MODE...

node.js连接mysql出现错误： ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client node.js连接mysql出现错误： ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client

目前是因为版本问题

1. 找到MYSQL的安装路径下的 bin 目录，这里是：C:\Program Files\MySQL\MySQL Server 8.0\bin，然后在命令行工具进入
2. 登录mysql，如下

 mysql -u root -p

3. 修改密码

 ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '新密码';

4. 刷新

 FLUSH PRIVILEGES;

这样就可以node连接mysql成功了。

mac在第一步找bin目录时进入

    // 进入
 /Users/usr/local/mysql/bin
    // 登录
 ./mysql -u root -p