nodejs连接mysql报错的问题

解决Error: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client问题

mysql版本问题,首先找到自己mysql安装的路径的bin目录,进入cmd

mysql -u root -p

然后输入密码登录,再分别输入下面两行即可

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '数据库密码';

FLUSH PRIVILEGES;
点赞

发表回复

电子邮件地址不会被公开。必填项已用 * 标注