错误Client does not support authentication protocol requested by server； consider upgrading解决方案

在做项目的时候发现node mysql 无法连接数据库，所以记录一下怎么debug

命令如下：

1、use mysql;

2、alter user ‘root’@‘localhost’ identified with mysql_native_password by ‘********’;

3、flush privileges;