Error: ER_NOT_SUPPORTED_AUTH_MODE

[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 (0.20.5), 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 :(

[dceejay]

What is your mysql server version ?
I think the library may not support some of the version 8 features.
mysqljs/mysql#2046

[ghost]

8.0.15 version

[ghost]

ok, wich version support? i will use supported version!

[ghost]

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

[juggledad]

A user reports (https://discourse.nodered.org/t/mysql-connection-error/20953/4) that you can do the following

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password'
Where root is your user, localhost is your URL and password is your password
Then run this query to refresh privileges:
flush privileges;