Express-mysql-session 이용하기

[이해욱]

const express =require('express');
const app = express();
const bodyParser= require('body-parser')
app.use(bodyParser.urlencoded({extended: true})) 
app.set('view engine', 'ejs');

var passport = require('passport');
var session = require("express-session");
var MySQLStore = require('express-mysql-session')(session);
app.use(
  session({
    secret: '1234DSFs@adfFER#1234!@#$asd',
    resave: false,
    saveUninitialized: true,
    store:new MySQLStore({
      host:'localhost',
      port:3306,
      user:'root',
      password:'***********,
      database:'moonserver'
    })
  })
);
app.use(passport.initialize());
app.use(passport.session());

const mysql = require('mysql2');
const methodOverride = require('method-override')
app.use(methodOverride('_method'))

const connection = mysql.createConnection({
host : 'localhost',  
user : 'root',
password : '***********',
database : 'moonserver'
});

app.use('/public', express.static('public'))

connection.connect(function(err) {
  if (err) {
    console.error('연결실패 :' + err.stack);
    return;
  }
  console.log('연결된듯');
});

이렇게 하면 moonserver db에 세션테이블이 생성되야하는데
새로고침 또는 mysql 검색해봐도 세션이 안생기네요
설정에서 오류 있는게있나요?

오류 내용입니다.
Error: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
    at Handshake.Sequence._packetToError (C:\Users\atolo\Desktop\server\node\node_modules\mysql\lib\protocol\sequences\Sequence.js:47:14)
    at Handshake.ErrorPacket (C:\Users\atolo\Desktop\server\node\node_modules\mysql\lib\protocol\sequences\Handshake.js:123:18)
    at Protocol._parsePacket (C:\Users\atolo\Desktop\server\node\node_modules\mysql\lib\protocol\Protocol.js:291:23)
    at Parser._parsePacket (C:\Users\atolo\Desktop\server\node\node_modules\mysql\lib\protocol\Parser.js:433:10)
    at Parser.write (C:\Users\atolo\Desktop\server\node\node_modules\mysql\lib\protocol\Parser.js:43:10)
    at Protocol.write (C:\Users\atolo\Desktop\server\node\node_modules\mysql\lib\protocol\Protocol.js:38:16)
    at Socket.<anonymous> (C:\Users\atolo\Desktop\server\node\node_modules\mysql\lib\Connection.js:88:28)
    at Socket.<anonymous> (C:\Users\atolo\Desktop\server\node\node_modules\mysql\lib\Connection.js:526:10)
    at Socket.emit (node:events:527:28)
    at addChunk (node:internal/streams/readable:315:12)
    --------------------
    at Protocol._enqueue (C:\Users\atolo\Desktop\server\node\node_modules\mysql\lib\protocol\Protocol.js:144:48)
    at Protocol.handshake (C:\Users\atolo\Desktop\server\node\node_modules\mysql\lib\protocol\Protocol.js:51:23)
    at PoolConnection.connect (C:\Users\atolo\Desktop\server\node\node_modules\mysql\lib\Connection.js:116:18)
    at Pool.getConnection (C:\Users\atolo\Desktop\server\node\node_modules\mysql\lib\Pool.js:48:16)
    at Pool.query (C:\Users\atolo\Desktop\server\node\node_modules\mysql\lib\Pool.js:202:8)    
    at MySQLStore.query (C:\Users\atolo\Desktop\server\node\node_modules\express-mysql-session\index.js:439:33)
    at MySQLStore.set (C:\Users\atolo\Desktop\server\node\node_modules\express-mysql-session\index.js:240:8)
    at Session.save (C:\Users\atolo\Desktop\server\node\node_modules\express-session\session\session.js:72:25)
    at Session.save (C:\Users\atolo\Desktop\server\node\node_modules\express-session\index.js:406:15)
    at ServerResponse.end (C:\Users\atolo\Desktop\server\node\node_modules\express-session\index.js:335:21)
Error: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
    at Handshake.Sequence._packetToError (C:\Users\atolo\Desktop\server\node\node_modules\mysql\lib\protocol\sequences\Sequence.js:47:14)
    at Handshake.ErrorPacket (C:\Users\atolo\Desktop\server\node\node_modules\mysql\lib\protocol\sequences\Handshake.js:123:18)
    at Protocol._parsePacket (C:\Users\atolo\Desktop\server\node\node_modules\mysql\lib\protocol\Protocol.js:291:23)
    at Parser._parsePacket (C:\Users\atolo\Desktop\server\node\node_modules\mysql\lib\protocol\Parser.js:433:10)
    at Parser.write (C:\Users\atolo\Desktop\server\node\node_modules\mysql\lib\protocol\Parser.js:43:10)
    at Protocol.write (C:\Users\atolo\Desktop\server\node\node_modules\mysql\lib\protocol\Protocol.js:38:16)
    at Socket.<anonymous> (C:\Users\atolo\Desktop\server\node\node_modules\mysql\lib\Connection.js:88:28)
    at Socket.<anonymous> (C:\Users\atolo\Desktop\server\node\node_modules\mysql\lib\Connection.js:526:10)
    at Socket.emit (node:events:527:28)
    at addChunk (node:internal/streams/readable:315:12)
    --------------------
    at Protocol._enqueue (C:\Users\atolo\Desktop\server\node\node_modules\mysql\lib\protocol\Protocol.js:144:48)
    at Protocol.handshake (C:\Users\atolo\Desktop\server\node\node_modules\mysql\lib\protocol\Protocol.js:51:23)
    at PoolConnection.connect (C:\Users\atolo\Desktop\server\node\node_modules\mysql\lib\Connection.js:116:18)
    at Pool.getConnection (C:\Users\atolo\Desktop\server\node\node_modules\mysql\lib\Pool.js:48:16)
    at Pool.query (C:\Users\atolo\Desktop\server\node\node_modules\mysql\lib\Pool.js:202:8)    
    at MySQLStore.query (C:\Users\atolo\Desktop\server\node\node_modules\express-mysql-session\index.js:439:33)
    at MySQLStore.get (C:\Users\atolo\Desktop\server\node\node_modules\express-mysql-session\index.js:162:8)
    at session (C:\Users\atolo\Desktop\server\node\node_modules\express-session\index.js:485:11)
    at Layer.handle [as handle_request] (C:\Users\atolo\Desktop\server\node\node_modules\express\lib\router\layer.js:95:5)
    at trim_prefix (C:\Users\atolo\Desktop\server\node\node_modules\express\lib\router\index.js:328:13)


const mysql = require('mysql'); 대신에
const mysql = require('mysql2');
도 사용해보고 

ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '********';도 해봤는데 안되네요

[codingapple]

검색하면 ALTER USER 어쩌구 뒤에 FLUSH PRIVILEGES; 도 실행해보라는군요

[글쓴이]

글