Node.js Tips: mysql8にはmysql2を使う

var mysql = require('mysql');
var mysqlSettings = {
    host : 'localhost',
    user : 'user',
    password : 'password',
    database : 'MyNodeAppDb'
};
var conn = mysql.createConnection(mysqlSettings);
conn.Connect(); //　←ここで発生

Error: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client

$> npm init
This utility will walk you through creating a package.json file.
It only covers the most common items, and tries to guess sensible defaults.

See `npm help init` for definitive documentation on these fields and exactly what they do.

Use `npm install <pkg>` afterwards to install a package and save it as a dependency in the package.json file.

Press ^C at any time to quit.
package name: (mysqladdcli)
version: (1.0.0)
description:
entry point: (index.js) app.js
test command:
git repository:
keywords:
author: Masatoshuw
license: (ISC)
About to write to /Users/**/MySqlAddCLI/package.json:

{
  "name": "mysqladdcli",
  "version": "1.0.0",
  "description": "",
  "main": "app.js",
  "scripts": {
    "test": "echo \"Error: no test specified\" && exit 1"
  },
  "author": "Masatoshuw",
  "license": "ISC"
}


Is this OK? (yes) yes
$>

$> npm install --save mysql

added 11 packages, and audited 12 packages in 1s

found 0 vulnerabilities
$>

// package.json
{
  "name": "mysqladdcli",
  "version": "1.0.0",
  "description": "",
  "main": "app.js",
  "scripts": {
    "test": "echo \"Error: no test specified\" && exit 1"
  },
  "author": "Masatoshuw",
  "license": "ISC",
  "dependencies": {
    "mysql": "^2.18.1"
  }
}

const  mysql = require('mysql');

const  connSettings = {
  host :  'localhost',
  user:  'user',
  password:  'password',
  database:  'MyNodeAppDb'
};

console.log('Create mysql connection.');
const  conn = mysql.createConnection(connSettings);

console.log('Connect to mysql server.');
conn.connect();

console.log('Execute query : get records from mydata table without any criterias.');
conn.query('SELECT * FROM mydata', (error, results, fields) => {
  if (error != null) {
    console.log(error);
  }
  for (let  idx  in  results) {
    const record = results[idx];
    console.log(record.id + ': [' + record.name + '] [' + record.mail + '] [' + record.age + ']');
  }
});

console.log('Connection close.');
conn.end();

$> node app.js
Create mysql connection.
Connect to mysql server.
Execute query : get records from mydata table without any criterias.
Error: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
    at Handshake.Sequence._packetToError (/Users/**/MySqlAddCLI/node_modules/mysql/lib/protocol/sequences/Sequence.js:47:14)
    at Handshake.ErrorPacket (/Users/**/MySqlAddCLI/node_modules/mysql/lib/protocol/sequences/Handshake.js:123:18)
    at Protocol._parsePacket (/Users/**/MySqlAddCLI/node_modules/mysql/lib/protocol/Protocol.js:291:23)
    at Parser._parsePacket (/Users/**/MySqlAddCLI/node_modules/mysql/lib/protocol/Parser.js:433:10)
    at Parser.write (/Users/**/MySqlAddCLI/node_modules/mysql/lib/protocol/Parser.js:43:10)
    at Protocol.write (/Users/**/MySqlAddCLI/node_modules/mysql/lib/protocol/Protocol.js:38:16)
    at Socket.<anonymous> (/Users/**/MySqlAddCLI/node_modules/mysql/lib/Connection.js:88:28)
    at Socket.<anonymous> (/Users/**/MySqlAddCLI/node_modules/mysql/lib/Connection.js:526:10)
    at Socket.emit (events.js:315:20)
    at addChunk (_stream_readable.js:309:12)
    --------------------
    at Protocol._enqueue (/Users/**/MySqlAddCLI/node_modules/mysql/lib/protocol/Protocol.js:144:48)
    at Protocol.handshake (/Users/**/MySqlAddCLI/node_modules/mysql/lib/protocol/Protocol.js:51:23)
    at Connection.connect (/Users/**/MySqlAddCLI/node_modules/mysql/lib/Connection.js:116:18)
    at Object.<anonymous> (/Users/**/MySqlAddCLI/app.js:14:6)
    at Module._compile (internal/modules/cjs/loader.js:1063:30)
    at Object.Module._extensions..js (internal/modules/cjs/loader.js:1092:10)
    at Module.load (internal/modules/cjs/loader.js:928:32)
    at Function.Module._load (internal/modules/cjs/loader.js:769:14)
    at Function.executeUserEntryPoint [as runMain] (internal/modules/run_main.js:72:12)
    at internal/main/run_main_module.js:17:47 {
  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
}
$>

$> npm uninstall --save mysql

emoved 11 packages, and audited 1 package in 575ms
  
found **0** vulnerabilities
$>

$> npm install --save mysql2

added 15 packages, and audited 16 packages in 929ms

found **0** vulnerabilities
$>

const  mysql = require('mysql2'); // ←ここをmysql2に変更

const  connSettings = {
  host :  'localhost',
  user:  'user',
  password:  'password',
  database:  'MyNodeAppDb'
};

console.log('Create mysql connection.');
const  conn = mysql.createConnection(connSettings);

console.log('Connect to mysql server.');
conn.connect();

console.log('Execute query : get records from mydata table without any criterias.');
conn.execute('SELECT * FROM mydata', (error, results, fields) => {　// ←ここをquery（）からexecute()に変更
  if (error != null) {
    console.log(error);
  }
  for (let  idx  in  results) {
    const  record = results[idx];
    console.log(record.id + ': [' + record.name + '] [' + record.mail + '] [' + record.age + ']');
    }
  });

console.log('Connection close.');
conn.end();

$> node app.js
Create mysql connection.
Connect to mysql server.
Execute query : get records from mydata table without any criterias.
Connection close.
1: [Taro] [Taro@yamada] [35]
2: [hanako] [hanako@flower] [29]
3: [sachiko] [sachiko@happy] [17]
4: [ichiro] [ichiro@baseball] [45]
5: [jiro] [jiro@change] [58]
6: [mami] [mami@mumemo] [9]
$>