nodejs接続mysqlエラーthrow err;//Rethrow non-MySQL errorsの解決方法

環境:mysql:8.0+;win10 ; 64ビット
エラーの主な情報:

D:\projects
odejs\blog-1
ode_modules\[email protected]@mysql\lib\protocol\Parser.js:437
      throw err; // Rethrow non-MySQL errors
      ^
Error: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
flush privileges;

解決方法:

//   mysql       ：123456
mysql -u root -p 

// 1.     alter user 'root'@'localhost' identified with mysql_native_password by   ;
mysql> alter user 'root'@'localhost' identified with mysql_native_password by '123456';
Query OK, 0 rows affected (0.43 sec)

// 2.      flush privileges;
mysql> flush privileges;
Query OK, 0 rows affected (0.05 sec)

//3.      
mysql> quit
Bye

nodejs環境再起動でnpm run dev