2021-07-04

var mysql = require('mysql');
console.log(mysql);
var pool = mysql.createPool({'host':'localhost','user':'root','password':'1986791206.l','database':'20210704'});
pool.getConnection(function(err,connection){
	if(err){
		console.log(err);
	}else{
		connection.query('SELECT * FROM `user`;',function(err,data){
			if(err){
				console.log(err);
			}else{
				console.log(data);
				connection.end();
			}
		});
	}
});
```nodejs访问数据库报错
 ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
    at Handshake.Sequence._packetToError (D:\HBuilderX项目文件\node-2\node_modules\mysql\lib\protocol\sequences\Sequence.js:47:14)
    at Handshake.ErrorPacket (D:\HBuilderX项目文件\node-2\node_modules\mysql\lib\protocol\sequences\Handshake.js:123:18)
    at Protocol._parsePacket (D:\HBuilderX项目文件\node-2\node_modules\mysql\lib\protocol\Protocol.js:291:23)
    at Parser._parsePacket (D:\HBuilderX项目文件\node-2\node_modules\mysql\lib\protocol\Parser.js:433:10)
    at Parser.write (D:\HBuilderX项目文件\node-2\node_modules\mysql\lib\protocol\Parser.js:43:10)
    at Protocol.write (D:\HBuilderX项目文件\node-2\node_modules\mysql\lib\protocol\Protocol.js:38:16)
    at Socket.<anonymous> (D:\HBuilderX项目文件\node-2\node_modules\mysql\lib\Connection.js:88:28)
    at Socket.<anonymous> (D:\HBuilderX项目文件\node-2\node_modules\mysql\lib\Connection.js:526:10)
    at Socket.emit (events.js:315:20)
    at addChunk (_stream_readable.js:295:12)
    --------------------
    at Protocol._enqueue (D:\HBuilderX项目文件\node-2\node_modules\mysql\lib\protocol\Protocol.js:144:48)
    at Protocol.handshake (D:\HBuilderX项目文件\node-2\node_modules\mysql\lib\protocol\Protocol.js:51:23)
    at PoolConnection.connect (D:\HBuilderX项目文件\node-2\node_modules\mysql\lib\Connection.js:116:18)
    at Pool.getConnection (D:\HBuilderX项目文件\node-2\node_modules\mysql\lib\Pool.js:48:16)
    at Object.<anonymous> (D:\HBuilderX项目文件\node-2\m.js:4:6)
    at Module._compile (internal/modules/cjs/loader.js:1137:30)
    at Object.Module._extensions..js (internal/modules/cjs/loader.js:1157:10)
    at Module.load (internal/modules/cjs/loader.js:985:32)
    at Function.Module._load (internal/modules/cjs/loader.js:878:14)
    at Function.executeUserEntryPoint [as runMain] (internal/modules/run_main.js:71:12) {
  code: 'ER_NOT_SUPPORTED_AUTH_MODE',
  errno: 1251,
  sqlMessage: 'Client does not support authentication protocol requested by server; consider upgrading MySQL client',
  sqlState: '08004',
  fatal: true

}
解决：  更新数据库的加密规则 

```sql
ALTER USER 'root'@'localhost' IDENTIFIED BY 'password' PASSWORD EXPIRE NEVER;
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '1986791206.l';
FLUSH PRIVILEGES;

数据库链接成功：
与数据库链接失败的报错图片如下