2
respostas

Erro ao inserir no banco: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client

Não manda as informações pro mysql.

Error: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client at Handshake.Sequence.packetToError (/Users/kaikdantas/Desktop/PROJETOAPI/node_modules/mysql/lib/protocol/sequences/Sequence.js:47:14) at Handshake.ErrorPacket (/Users/kaikdantas/Desktop/PROJETO_API/node_modules/mysql/lib/protocol/sequences/Handshake.js:123:18) at Protocol.parsePacket (/Users/kaikdantas/Desktop/PROJETOAPI/node_modules/mysql/lib/protocol/Protocol.js:291:23) at Parser.parsePacket (/Users/kaikdantas/Desktop/PROJETOAPI/node_modules/mysql/lib/protocol/Parser.js:433:10) at Parser.write (/Users/kaikdantas/Desktop/PROJETO_API/node_modules/mysql/lib/protocol/Parser.js:43:10) at Protocol.write (/Users/kaikdantas/Desktop/PROJETO_API/node_modules/mysql/lib/protocol/Protocol.js:38:16) at Socket. (/Users/kaikdantas/Desktop/PROJETO_API/node_modules/mysql/lib/Connection.js:88:28) at Socket. (/Users/kaikdantas/Desktop/PROJETO_API/node_modules/mysql/lib/Connection.js:526:10) at Socket.emit (events.js:315:20)

at addChunk (internal/streams/readable.js:309:12)
--------------------
at Protocol._enqueue (/Users/kaikdantas/Desktop/PROJETO_API/node_modules/mysql/lib/protocol/Protocol.js:144:48)
at Protocol.handshake (/Users/kaikdantas/Desktop/PROJETO_API/node_modules/mysql/lib/protocol/Protocol.js:51:23)
at Connection.connect (/Users/kaikdantas/Desktop/PROJETO_API/node_modules/mysql/lib/Connection.js:116:18)
at Object.<anonymous> (/Users/kaikdantas/Desktop/PROJETO_API/index.js:4:9)
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 }

2 respostas

O erro pode estar acontecedo por conta do modulo >>mysql<< Voce tentar no terminal instalar o mysql2 npm i mysql2 Depois é só importar o mysql2 pro arquivo const mysql = require('mysql2') Espero ter Ajudado! :)

Pra mim ajudou!

Valeu Patrick!