MySQL connection Error

[Avipur]

Hi All,

I am beginner to Node Red . I am trying to connect MySQL database using "node-red-node-mysql" through a simple MySQL Query . I am getting following error

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

MySQL version is 8.0
Node Red Node-RED version: v1.0.3
Node.js version: v12.13.1

The MySQL Node Settings are as follows

Please help In case anybody has come across this issue and solved .

Thanks in Advance.

[zenofmud]

Looks like version 8 is not currently supported (see: https://github.com/node-red/node-red-nodes/issues/534)

[Bobo]

Not sure if this is a solution for you but I get the same error with Mariadb.

Doing a "grant all privileges on mydb.* to myuser identified by 'mypassword';" solved it for me.

[Avipur]

Thanks for your response.

I just found the solution on MySql forum and it is working with version 8.0

The solution is as follows

Execute the following query in MYSQL Workbench

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password'

Where root as your user localhost as your URL and password as your password

Then run this query to refresh privileges:

flush privileges;

[Avipur]

Thanks for your response. I could solve this issue by following solution provided on MySQl forum.
The Solution is as follows
Execute the following query in MYSQL Workbench

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password'

Where root as your user localhost as your URL and password as your password

Then run this query to refresh privileges:

flush privileges;