Mysql: Error: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server

[diogocsc]

F:\Projetos\Papo A Papo\in between>node mysql_boot.js
Could not establish a connection to the database
F:\Projetos\Papo A Papo\in between\mysql_boot.js:55
        throw error;
        ^

Error: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protoc
ol requested by server; consider upgrading MySQL client

[Spike-86]

+1 Me to (((

[dougwilson]

I am working on getting some of this support added now. But if you can say which specific plugin you user is using, I can make sure your specific case is supported before closing the issue after plugin support is added.

[eyedean]

Hi @dougwilson,

Is there a chance that we get https://github.com/mysqljs/mysql/pull/1962/ (or basically caching_sha2_password as default auth plugin of MySQL 8) anytime soon in here?

_Background:_ I found tens of issues here asking for this functionality since at least three years ago, and the only one that I found with some progress was https://github.com/mysqljs/mysql/issues/1959 by @ruiquelhas which was pending your volunteer work to fix/rebase on Sep 2018 and by now is 69 commits behind master.

I thought maybe that's fallen off from your list, so I moved to MySQL Connector/Node.js with X DevAPI by MySQL, which I think is led by Rui. Unfortunately their documentation (on the Node.js) is not as detailed, and more importantly there is no Typescript support (definition file) on their package.

So after one week of moving around, and trying so many different solution for my not-so-uncommon stack of TS+Node+MySQL8, I just saw your message here and it made me hopeful that I might be able to get what I want, here!

Thanks, anyways. :)

[dougwilson]

Hi @eyedean that's what I'm referring to above when I said I am working to get this in currently. The PR with all the issues addressed just came in less than 1 week ago... (5 days ago) #2233

But unless you can tell me if that will resolve the issue @diogocsc is having, your comment is likely off topic for this issue. I don't want to close @diogocsc issue if they are using a different plugin...

[diogocsc]

I worked around the issue by reinstalling MySQL8.0 in legacy mode.

[dougwilson]

Duplicate of https://github.com/mysqljs/mysql/issues/1959