2
respostas

Error: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication prot

{ Error: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication prot ocol requested by server; consider upgrading MySQL client at Handshake.Sequence._packetToError (C:\Users\FalconHeavy\Desktop\estudos n ode\casadodocodigo\node_modules\mysql\lib\protocol\sequences\Sequence.js:52:14) at Handshake.ErrorPacket (C:\Users\FalconHeavy\Desktop\estudos node\casadodo codigo\node_modules\mysql\lib\protocol\sequences\Handshake.js:130:18) at Protocol._parsePacket (C:\Users\FalconHeavy\Desktop\estudos node\casadodo codigo\node_modules\mysql\lib\protocol\Protocol.js:279:23) at Parser.write (C:\Users\FalconHeavy\Desktop\estudos node\casadodocodigo\no de_modules\mysql\lib\protocol\Parser.js:76:12) at Protocol.write (C:\Users\FalconHeavy\Desktop\estudos node\casadodocodigo\ node_modules\mysql\lib\protocol\Protocol.js:39:16) at Socket. (C:\Users\FalconHeavy\Desktop\estudos node\casadodocod igo\node_modules\mysql\lib\Connection.js:103:28) at emitOne (events.js:116:13) at Socket.emit (events.js:211:7) at addChunk (_stream_readable.js:263:12)

at readableAddChunk (_stream_readable.js:250:11)

at Protocol._enqueue (C:\Users\FalconHeavy\Desktop\estudos node\casadodocodi go\node_modules\mysql\lib\protocol\Protocol.js:145:48) at Protocol.handshake (C:\Users\FalconHeavy\Desktop\estudos node\casadodocod igo\node_modules\mysql\lib\protocol\Protocol.js:52:23) at Connection.connect (C:\Users\FalconHeavy\Desktop\estudos node\casadodocod igo\node_modules\mysql\lib\Connection.js:130:18) at Connection._implyConnect (C:\Users\FalconHeavy\Desktop\estudos node\casad odocodigo\node_modules\mysql\lib\Connection.js:461:10) at Connection.query (C:\Users\FalconHeavy\Desktop\estudos node\casadodocodig o\node_modules\mysql\lib\Connection.js:206:8) at C:\Users\FalconHeavy\Desktop\estudos node\casadodocodigo\app\routes\produ tos.js:9:14 at Layer.handle [as handle_request] (C:\Users\FalconHeavy\Desktop\estudos no de\casadodocodigo\node_modules\express\lib\router\layer.js:95:5) at next (C:\Users\FalconHeavy\Desktop\estudos node\casadodocodigo\node_modul es\express\lib\router\route.js:137:13) at Route.dispatch (C:\Users\FalconHeavy\Desktop\estudos node\casadodocodigo\ node_modules\express\lib\router\route.js:112:3) at Layer.handle [as handle_request] (C:\Users\FalconHeavy\Desktop\estudos no de\casadodocodigo\node_modules\express\lib\router\layer.js:95:5) code: 'ER_NOT_SUPPORTED_AUTH_MODE', errno: 1251, sqlMessage: 'Client does not support authentication protocol requested by serv er; consider upgrading MySQL client', sqlState: '08004', fatal: true }

2 respostas

Oi Thompson, outros alunos tiveram problemas parecidos e compartilharam a solução com a gente, vê se funciona pra você também por favor?

https://cursos.alura.com.br/forum/topico-pagina-carrega-em-branco-29499

Olá, comigo ocorreu o mesmo erro.

O problema é que a forma descrita no curso não é compatível com novo mysql (versão 8).

Desinstalei a versão 8 e instalei a versão 5.7, funcionou.

Segue o link:https://dev.mysql.com/downloads/file/?id=478035.