mysql 연결 오류

mysql 계정을 만들때 오류가 발생하는데, 원래 비밀번호 policy가 medium이여서 복잡했는데, show variables like 'validate_password%';를 통해 비밀번호 정책을 확인하고, set global validate_password=LOW;를 해서 low로 설정해서 mysql 계정을 만들었다.

 

.env를 이용해서 sql을 연결하려고 하니 오류가 발생했다. 그 이유는 MYSQL_PASSWORD에 들어가는 비밀번호가 8자리여야 하는데, 4자리 비밀번호를 사용해서 오류가 발생했다.

오류 메세지

Error: ER_ACCESS_DENIED_ERROR: Access denied for user 'dev01'@'localhost' (using password: YES)
    at Sequence._packetToError (/Users/SaintKim/node_modules/mysql/lib/protocol/sequences/Sequence.js:47:14)
    at Handshake.ErrorPacket (/Users/SaintKim/node_modules/mysql/lib/protocol/sequences/Handshake.js:123:18)
    at Protocol._parsePacket (/Users/SaintKim/node_modules/mysql/lib/protocol/Protocol.js:291:23)
    at Parser._parsePacket (/Users/SaintKim/node_modules/mysql/lib/protocol/Parser.js:433:10)
    at Parser.write (/Users/SaintKim/node_modules/mysql/lib/protocol/Parser.js:43:10)
    at Protocol.write (/Users/SaintKim/node_modules/mysql/lib/protocol/Protocol.js:38:16)
    at Socket.<anonymous> (/Users/SaintKim/node_modules/mysql/lib/Connection.js:88:28)
    at Socket.<anonymous> (/Users/SaintKim/node_modules/mysql/lib/Connection.js:526:10)
    at Socket.emit (node:events:517:28)
    at addChunk (node:internal/streams/readable:368:12)
    --------------------
    at Protocol._enqueue (/Users/SaintKim/node_modules/mysql/lib/protocol/Protocol.js:144:48)
    at Protocol.handshake (/Users/SaintKim/node_modules/mysql/lib/protocol/Protocol.js:51:23)
    at PoolConnection.connect (/Users/SaintKim/node_modules/mysql/lib/Connection.js:116:18)
    at Pool.getConnection (/Users/SaintKim/node_modules/mysql/lib/Pool.js:48:16)
    at Pool.query (/Users/SaintKim/node_modules/mysql/lib/Pool.js:202:8)
    at /Users/SaintKim/Documents/mysql/index.js:16:48
    at new Promise (<anonymous>)
    at Object.query (/Users/SaintKim/Documents/mysql/index.js:16:10)
    at /Users/SaintKim/Documents/mysql/app_mysql.js:12:32
    at Layer.handle [as handle_request] (/Users/SaintKim/node_modules/express/lib/router/layer.js:95:5) {
  code: 'ER_ACCESS_DENIED_ERROR',
  errno: 1045,
  sqlMessage: "Access denied for user 'dev01'@'localhost' (using password: YES)",
  sqlState: '28000',
  fatal: true
}
node:internal/process/promises:288
            triggerUncaughtException(err, true /* fromPromise */);
            ^

[UnhandledPromiseRejection: This error originated either by throwing inside of an async function without a catch block, or by rejecting a promise which was not handled with .catch(). The promise rejected with the reason "#<Object>".] {
  code: 'ERR_UNHANDLED_REJECTION'
}