node+mysql8.0的报错问题

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

初始化 node + mysql8.0 (midway+typeorm) 时遇到报错，提示不支持mysql的加密

 

解决办法： 

去mysql中执行

alter user 'root'@'localhost' identified with mysql_native_password by 'xxx';

其中 'xxx' 为 root 的密码

 

可以通过命令行登录执行，或在navicat中新建查询执行