vscode-mysql
vscode-mysql copied to clipboard
formulahendry
it doesn't support mysql_8.0.11 ?
Error: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
Depends on the upstream mysql npm: https://github.com/mysqljs/mysql/issues/2002
@formulahendry thank you. i change the authentication method of mysql and it works.
@cuakitiang I have same problem, can you tell me how you solved it please! How you change authintecation method ?? Please ....
@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
@Osuriel Because this extension relies on the mysql npm package, and this package has the issue: https://github.com/mysqljs/mysql/issues/2002
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 [email protected] 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.
@Osuriel Please refer to https://softwareengineering.stackexchange.com/a/83686
@formulahendry thank you so much! Makes sense! You just helped me become a lil better developer than I was yesterday! 💪🏽
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 :(
i using previous version (5.7.25) all, ok, we will waiting update, best regards!