Entrar Ainda não tem acesso?
6
respostas

code: 'ER_NOT_SUPPORTED_AUTH_MODE'

Referente ao curso Rest com NodeJS: API com Express e MySQL, no capítulo Persistindo nossos dados e atividade Criando nossa base de dados com MySQL

por Rodrigo Donizetti Gabiati
| 105.3k xp | 6 posts

Meu VS Code ta dando o seguinte erro, sendo que estou usando a versão mais nova do 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\Digoo\OneDrive\Documentos\VS_Code\Alura\RestComNodeJS\node_modules\mysql\lib\protocol\sequences\Sequence.js:47:14)
    at Handshake.ErrorPacket (C:\Users\Digoo\OneDrive\Documentos\VS_Code\Alura\RestComNodeJS\node_modules\mysql\lib\protocol\sequences\Handshake.js:123:18)
    at Protocol._parsePacket (C:\Users\Digoo\OneDrive\Documentos\VS_Code\Alura\RestComNodeJS\node_modules\mysql\lib\protocol\Protocol.js:291:23)  
    at Parser._parsePacket (C:\Users\Digoo\OneDrive\Documentos\VS_Code\Alura\RestComNodeJS\node_modules\mysql\lib\protocol\Parser.js:433:10)      
    at Parser.write (C:\Users\Digoo\OneDrive\Documentos\VS_Code\Alura\RestComNodeJS\node_modules\mysql\lib\protocol\Parser.js:43:10)
    at Protocol.write (C:\Users\Digoo\OneDrive\Documentos\VS_Code\Alura\RestComNodeJS\node_modules\mysql\lib\protocol\Protocol.js:38:16)
    at Socket.<anonymous> (C:\Users\Digoo\OneDrive\Documentos\VS_Code\Alura\RestComNodeJS\node_modules\mysql\lib\Connection.js:88:28)
    at Socket.<anonymous> (C:\Users\Digoo\OneDrive\Documentos\VS_Code\Alura\RestComNodeJS\node_modules\mysql\lib\Connection.js:526:10)
    at Socket.emit (events.js:311:20)
    at addChunk (_stream_readable.js:294:12)
    --------------------
    at Protocol._enqueue (C:\Users\Digoo\OneDrive\Documentos\VS_Code\Alura\RestComNodeJS\node_modules\mysql\lib\protocol\Protocol.js:144:48)      
    at Protocol.handshake (C:\Users\Digoo\OneDrive\Documentos\VS_Code\Alura\RestComNodeJS\node_modules\mysql\lib\protocol\Protocol.js:51:23)      
    at Connection.connect (C:\Users\Digoo\OneDrive\Documentos\VS_Code\Alura\RestComNodeJS\node_modules\mysql\lib\Connection.js:116:18)
    at Object.<anonymous> (C:\Users\Digoo\OneDrive\Documentos\VS_Code\Alura\RestComNodeJS\index.js:4:9)
    at Module._compile (internal/modules/cjs/loader.js:1158:30)
    at Object.Module._extensions..js (internal/modules/cjs/loader.js:1178:10)
    at Module.load (internal/modules/cjs/loader.js:1002:32)
    at Function.Module._load (internal/modules/cjs/loader.js:901:14)
    at Function.executeUserEntryPoint [as runMain] (internal/modules/run_main.js:74:12)
    at internal/main/run_main_module.js:18: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
}
6 respostas
por Ivanize Siqueira Accessor
| 58.1k xp | 1 posts

Também estou recebendo esse erro. Alguém pode ajudar?

[nodemon] starting node index.js 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\isa13\alura\nodemodules\mysql\lib\protocol\sequences\Sequence.js:47:14) at Handshake.ErrorPacket (C:\Users\isa13\alura\node_modules\mysql\lib\protocol\sequences\Handshake.js:123:18) at Protocol.parsePacket (C:\Users\isa13\alura\nodemodules\mysql\lib\protocol\Protocol.js:291:23) at Parser.parsePacket (C:\Users\isa13\alura\nodemodules\mysql\lib\protocol\Parser.js:433:10) at Parser.write (C:\Users\isa13\alura\node_modules\mysql\lib\protocol\Parser.js:43:10) at Protocol.write (C:\Users\isa13\alura\node_modules\mysql\lib\protocol\Protocol.js:38:16) at Socket. (C:\Users\isa13\alura\node_modules\mysql\lib\Connection.js:88:28) at Socket. (C:\Users\isa13\alura\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 (C:\Users\isa13\alura\node_modules\mysql\lib\protocol\Protocol.js:144:48)
at Protocol.handshake (C:\Users\isa13\alura\node_modules\mysql\lib\protocol\Protocol.js:51:23)
at Connection.connect (C:\Users\isa13\alura\node_modules\mysql\lib\Connection.js:116:18)
at Object.<anonymous> (C:\Users\isa13\alura\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 } [nodemon] clean exit - waiting for changes before restart

por Bruno Pires de Oliveira
| 72.3k xp | 5 posts

Mesmo erro aqui, help

por Estudante
| 203.8k xp | 50 posts

Aqui também!

por William Santos Barbosa da Costa
| 66.3k xp | 4 posts
Analista de Sistemas Junior

Estou com o mesmo erro...

por William Santos Barbosa da Costa
| 66.3k xp | 4 posts
Analista de Sistemas Junior

Executei a seguinte query no mysql e resolveu o problema de conexão:

usuario = colocar o nome do usuário do banco senha= colocar a senha do usuário informado

ALTER USER 'usuario'@'localhost' IDENTIFIED WITH mysql_native_password BY 'senha';
por Marco Antonio Smanioto
| 50.8k xp | 2 posts

Estou com o mesmo problema porque estou usando o docker do mysql e ele tem um problema com o AllowPublicKeyRetrieval que precisa ser True(para quem usa dBeaver aí por exemplo)....

Consegui resolver da seguinte forma :

no terminal, instale o módulo mysql2 utilizando o npm install mysql2

Toquei o require da seguinte forma :

const mysql = require('mysql') por const mysql = require('mysql2')

Esperto ter ajudado...

Abs,

Marco A. Smanioto