ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client

[zhangzheng0529]

May any tech savvy tell me why this happens in vscode? I can use the same configuration without any problem when working with mySQL.

[rabinage]

Connecting with a user having "Authentication Type" set to Standard worked for me. I guess you need to provide a path to SSL certs if you try to connect using root user.

[ghost]

If you're trying connect to a 8.X version of MySql, with a user using the newly introduced 8.X caching_sha2_password default auth plugin method, I think you're running into the issue addressed here in this SO question. This VS plugin has a dependency on the mysql npm package and as far as I know the PR/issue referenced in the SO link has not yet been resolved.

[OnkelTem]

@calexa22 Seems like it's not resolved even now, 3 years later.

And out-of-the-box, this plugin just doesn't work on the mainstream Ubuntu 20.04 LTS release. I feel some Windows influence here...

This plugin is used by 800k people. Each one of them has to weaken their security by disabling caching_sha2_password because contributors didn't have a chance to update the extension. We're bad contributors then...

[z0z0r4]

hmmmm, any one could fix this problems?3 years later...