起因:Windows系统装MySQL后,Node.js服务和Navicat for MySQL连接MySQL报错。
报错信息:
Client does not support authentication protocol requested by server; consider upgrading MySQL client
解决方案:
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'yourpassword';