创建连接的代码
const mysql = require('mysql');
const dbConn = mysql.createConnection({
host: 'localhost',
port: 3306,
user: 'root',
password: '123456',
database: 'test'
});
dbConn.connect(err => {
if (err) throw err;
console.log('Connected!');
});
MySQL 8.0 root帐户使用新密码哈希方法:
> select User,Host,plugin from user where User="root";
+------+-----------+-----------------------+
| User | Host | plugin |
+------+-----------+-----------------------+
| root | localhost | caching_sha2_password |
+------+-----------+-----------------------+
解决方案:
解决方法是更改用户帐户的类型以使用旧的身份验证插件:
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '123456';
或者是创建一下:
CREATE USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '123456';