使用node.js连接mysql8+版本出现错误

node连接mysql出现：Client does not support authentication protocol requested by server; consider upgrading MySQL client

解决方法：

一、cmd运行mysql

二、修改mysql密码规则

ALTER USER 'root'@'localhost' IDENTIFIED BY 'password' PASSWORD EXPIRE NEVER;

三、更改新的密码

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

四、刷新权限

FLUSH PRIVILEGES;