使用node连接MySQL数据库时遇到的问题。报错：Client does not support authentication protocol requested by server; consider upgrading MySQL client

Client does not support authentication protocol requested by server; consider upgrading MySQL client

数据库连接失败，

在mysql窗口执行

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

代码然后：

flush privileges;

重新加载权限表操作。再次运行js文件即可与MySQL数据库连接成功。