Não consigo fazer uma conexão simples com o servidor por algum motivo. Baixei o mySQL versão 8.0.22 e o workbench versão 8.0.16 por questões de compatibilidade com o sistema.
Vou deixar abaixo o erro.
Error: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
at Handshake.Sequence._packetToError (/Users/gladstonsc/LXPVN/ProjectNode/node_modules/mysql/lib/protocol/sequences/Sequence.js:47:14)
at Handshake.ErrorPacket (/Users/gladstonsc/LXPVN/ProjectNode/node_modules/mysql/lib/protocol/sequences/Handshake.js:123:18)
at Protocol._parsePacket (/Users/gladstonsc/LXPVN/ProjectNode/node_modules/mysql/lib/protocol/Protocol.js:291:23)
at Parser._parsePacket (/Users/gladstonsc/LXPVN/ProjectNode/node_modules/mysql/lib/protocol/Parser.js:433:10)
at Parser.write (/Users/gladstonsc/LXPVN/ProjectNode/node_modules/mysql/lib/protocol/Parser.js:43:10)
at Protocol.write (/Users/gladstonsc/LXPVN/ProjectNode/node_modules/mysql/lib/protocol/Protocol.js:38:16)
at Socket.<anonymous> (/Users/gladstonsc/LXPVN/ProjectNode/node_modules/mysql/lib/Connection.js:88:28)
at Socket.<anonymous> (/Users/gladstonsc/LXPVN/ProjectNode/node_modules/mysql/lib/Connection.js:526:10)
at Socket.emit (events.js:210:5)
at addChunk (_stream_readable.js:308:12)
--------------------
at Protocol._enqueue (/Users/gladstonsc/LXPVN/ProjectNode/node_modules/mysql/lib/protocol/Protocol.js:144:48)
at Protocol.handshake (/Users/gladstonsc/LXPVN/ProjectNode/node_modules/mysql/lib/protocol/Protocol.js:51:23)
at Connection.connect (/Users/gladstonsc/LXPVN/ProjectNode/node_modules/mysql/lib/Connection.js:116:18)
at Object.<anonymous> (/Users/gladstonsc/LXPVN/ProjectNode/index.js:4:11)
at Module._compile (internal/modules/cjs/loader.js:956:30)
at Object.Module._extensions..js (internal/modules/cjs/loader.js:973:10)
at Module.load (internal/modules/cjs/loader.js:812:32)
at Function.Module._load (internal/modules/cjs/loader.js:724:14)
at Function.Module.runMain (internal/modules/cjs/loader.js:1025:10)
at internal/main/run_main_module.js:17:11 {
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
}