Nodejs 连接数据库报错--MySQL8.0

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

在 MYSQL Workbench 或者cmd 中执行以下查询

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';

如图所示:

然后运行:

flush privileges;

刷新MySQL的权限

如下图所示:

此后重新使用连接测试。成功！