问题:
mysql 报错:ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
原因:
Node不支持mysql8.0以上加密方式。
解决:
- 快捷键
win+r
打开CMD - 登录mysql
mysql -u root -p
- 运行命令
alter user 'root'@'localhost' identified with mysql_native_password by '123456';
- 运行命令
flush privileges;