ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
解决办法:
1. 找到MYSQL的安装路径下的bin目录,"C:\Program Files\MySQL\MySQL Server 8.0\bin",然后在命令提示符cd "C:\Program Files\MySQL\MySQL Server 8.0\bin"进入到文件夹
2.登录mysql数据库。输入:
mysql -u root -p
,进入数据库,输入自己数据库的密码
3.接着输入 : ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '密码';
4.最后在输入:FLUSH PRIVILEGES;
最后重新启动js文件连接数据库
const mysql = require("mysql");
const db = mysql.createPool({
host: "127.0.0.1",//数据库连接服务
user: "root",//数据库用户名
password: "123",//数据库密码
database: "demo",//选择要操作的库房
})
//是否连接成功
db.query('select 1', (err, results) => {
if (err) return console.log(err.message);
console.log(results);
})