node链接MySQL报错

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

解决方案:

切换到mysql数据库

1.alter user 'root'@'localhost' identified with mysql_native_password by '123456';

控制台输出信息:Query OK, 0 rows affected (0.10 sec)

2.flush privileges;

控制台输出信息:Query OK, 0 rows affected (0.01 sec)

即可重新登录。

参考来源:https://blog.csdn.net/u012965373/article/details/81206241