error:==Error:ER_NOT_SUPPORTED_AUTH_MODE:Clientdoesnotsupportauthenticationprotocolbyserver;considerupgradeMySQLclient==这个报错是客户端的解决办法就是如果不支持服务器请求的认证协议,修改加密规则1.打开命令行,输入以下命令$mysql-uroot-p输入密码2.再次输入,将密码替换为你自己的密码mysql>ALTERUSER'root'@'localhost'IDENTIFIEDBY'password'PASSWORDEXPIRENEVER;3.重新输入密码并用你自己的密码替换密码mysql>ALTERUSER'root'@'localhost'IDENTIFIEDWITHmysql_native_passwordBY'password';4.刷新权限mysql>FLUSHPRIVILEGES;5.更新密码重新连接即可,此时可能会报错,==Error:connectECONNREFUSED127.0.0.1:3306==解决方法:constmysql=require('mysql');letdb=mysql.createConnection({主机:'localhost',用户:'root',密码:'123456',socketPath:'/tmp/mysql.sock',数据库:'testDb'});
