it doesn't support mysql_8.0.11 ?

[caiqichang]

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

[formulahendry]

Depends on the upstream mysql npm: mysqljs/mysql#2002

[caiqichang]

@formulahendry thank you. i change the authentication method of mysql and it works.

[gisaac85]

@cuakitiang 
I have same problem, can you tell me how you solved it please!
How you change authintecation method ??
Please ....

[caiqichang]

@gisaac85
ALTER USER 'username'@'host' IDENTIFIED WITH 'mysql_native_password' BY 'password';
you can check it:
USE mysql;
SELECT plugin FROM user WHERE User = 'username';
by the way, you may need root permissions

[gisaac85]

Thanks a lot 👍👍🥇🥇

[Osuriel]

@formulahendry
What do you mean with "Depends on the upstream" ?

[formulahendry]

@Osuriel Because this extension relies on the mysql npm package, and this package has the issue: mysqljs/mysql#2002

[Osuriel]

I guess my question now is what is an upstream? Sorry junior dev here. - Omar Suriel

…

On Jul 18, 2018, at 5:00 AM, Jun Han ***@***.***> wrote: @Osuriel Because this extension relies on the mysql npm package, and this package has the issue: mysqljs/mysql#2002 — You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub, or mute the thread.

[formulahendry]

@Osuriel Please refer to https://softwareengineering.stackexchange.com/a/83686

[Osuriel]

@formulahendry thank you so much! Makes sense! You just helped me become a lil better developer than I was yesterday! 💪🏽

[ghost]

hi, everyone, i have this problem: "Error: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client"
i have installed latest nodered, and latest version of flow 0.0.18 (https://flows.nodered.org/node/node-red-node-mysql)
i run mysql in docker from https://hub.docker.com/_/mysql, but i cannot connect :(

[ghost]

i using previous version (5.7.25) all, ok, we will waiting update, best regards!