問題描述node版本為8.9.2,連接mysql8.0，顯示連接成功但是報錯，報錯為：Error: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client相關代碼const mysql = require('mysql')const db = mysql.createConnection({
host: 'localhost',
user: 'root',
password: '123456',
database: 'test_self',
})
db.query('SELECT * FROM `users`', (err, data) => { console.log('成功') // 這里可以打出'成功'
if (err) { console.log(err) // 這里報錯
} else { console.log(data)
}
})
添加回答
舉報
0/150
提交
取消