报错显示:ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
原因:Mysql8.0版本之后与登录数据库的客户端不兼容了,8.0密码认证采用了新的密码格式
解决方法:
(1)打开cmd
(2)输入mysql -u root -p
(3)然后再输入 ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password',这里的password是你自己的密码
(4)之后再重新运行node app.js,然后再打开127.0.0.1:+端口号+/接口号