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

解决MySQL连接出错问题

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

A StackOverflow answer suggested to use the old password hash algorithm, and the following statement worked, enabling a NodeJS Sequelize client authenticate.
stackoverflow答案建议使用旧的密码散列算法，下面的语句可以工作，从而使nodejs连续进行客户机身份验证。

在windows电脑上打开MySQL命令行，输入密码登录，执行下方语句，USER PASSWORD替换成自己的用户名和密码。

alter user 'USER'@'localhost' identified with mysql_native_password by 'PASSWORD'

使用上面这条SQL语句即可解决问题。

方法链接：问题描述及解决