mysql8 修改用户密码登陆模式

修改mysql 密码登陆模式—mysql_native_password

在node.js 中报错如下：

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

1
2
3

use mysql;
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password'
flush privileges;