使用NodeJS连接到MySQL数据库时,运行项目,出现如下错误:
throw err; // Rethrow non-MySQL errors
^
Error: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
at Handshake.Sequence._packetToError (D:\projects\node\BlogSystem\blog\node_modules\mysql\lib\protocol\sequences\Sequence.js:47:14)
at Handshake.ErrorPacket (D:\projects\node\BlogSystem\blog\node_modules\mysql\lib\protocol\sequences\Handshake.js:123:18)
at Protocol._parsePacket (D:\projects\node\BlogSystem\blog\node_modules\mysql\lib\protocol\Protocol.js:291:23)
at Parser._parsePacket (D:\projects\node\BlogSystem\blog\node_modules\mysql\lib\protocol\Parser.js:433:10)
at Parser.write (D:\projects\node\BlogSystem\blog\node_modules\mysql\lib\protocol\Parser.js:43:10)
at Protocol.write (D:\projects\node\BlogSystem\blog\node_modules\mysql\lib\protocol\Protocol.js:38:16)
at Socket.<anonymous> (D:\projects\node\BlogSystem\blog\node_modules\mysql\lib\Connection.js:91:28)
at Socket.<anonymous> (D:\projects\node\BlogSystem\blog\node_modules\mysql\lib\Connection.js:525:10)
at Socket.emit (events.js:198:13)
at addChunk (_stream_readable.js:288:12)
--------------------
at Protocol._enqueue (D:\projects\node\BlogSystem\blog\node_modules\mysql\lib\protocol\Protocol.js:144:48)
at Protocol.handshake (D:\projects\node\BlogSystem\blog\node_modules\mysql\lib\protocol\Protocol.js:51:23)
at Connection.connect (D:\projects\node\BlogSystem\blog\node_modules\mysql\lib\Connection.js:119:18)
at Object.<anonymous> (D:\projects\node\BlogSystem\blog\database.js:17:10)
at Module._compile (internal/modules/cjs/loader.js:778:30)
at Object.Module._extensions..js (internal/modules/cjs/loader.js:789:10)
at Module.load (internal/modules/cjs/loader.js:653:32)
at tryModuleLoad (internal/modules/cjs/loader.js:593:12)
at Function.Module._load (internal/modules/cjs/loader.js:585:3)
at Function.Module.runMain (internal/modules/cjs/loader.js:831:12)
我的数据库连接代码为:
/*数据库配置文件*/
const mysql = require('mysql')
const config = require('./config')
// 连接数据库
const database = mysql.createConnection({
host:config.host,
user:config.user,
port:config.port,
password:config.password,
database:config.database
});
database.connect(function(err) {
if(err) throw err;
console.log("connected!");
});
module.exports = database;
出现上述错误的原因是您使用了太新的 MySQL 数据库(版本> = 8.x)。
旧的 MySQL 版本(5.x)使用身份验证插件,例如 SHA256_PASSWORD。
在 MySQL的8.x的 版本使用身份验证插件,如 SHA2_PASSWORD。
NodeJS MySQL库尚未更改。它使用身份验证插件(例如 SHA256_PASSWORD),并且不支持 SHA2_PASSWORD。
为了克服以上错误,
方法一:打开 “ MySQL Command Line Client” 窗口并执行以下命令:
# Syntax:
ALTER USER 'my_username'@'my_host' IDENTIFIED WITH 'mysql_native_password' BY 'my_password';
# Example:
ALTER USER 'root'@'localhost' IDENTIFIED WITH 'mysql_native_password' BY '12345';
另一种方法是,您还可以 从connection_string创建一个 Connection对象 :
var connString = 'mysql://myuser:mypass@myhost/mdb?charset=utf8_general_ci&timezone=-0700';
var conn = mysql.createConnection(connString);