当我执行命令node xxx.js
时,报错信息如下:
code: 'ER_NOT_SUPPORTED_AUTH_MODE',
errno: 1251,
sqlMessage: 'Client does not support authentication protocol requested by server;
consider upgrading MySQL client',
sqlState: '08004',
fatal: true
解决办法:
1、首先登录MySQL服务器:
$ mysql -u root -p
2、然后输入如下命令:
ALTER USER 'root'@'localhost' IDENTIFIED BY '你自己的密码';
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '你自己的密码';