ER_NOT_SUPPORTED_AUTH_MODE

#1

Hello, I have the following problem, I want to connect with the node network to an external database, that is to say with a different IP but of the same range.
In the MySQL-Worbench program, everything is well configured and connected to the MySQL-Server. The problem is when I transfer the data from the node-red to MySQL.
Note: The users have all the privileges.
The problem is the following: "Error: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client"!

#2

so what MySQL server are you running?

#3

MysQL Server

#4

so what version?

#5

8.0, the last

#6

You haven't mentioned which of the SQL nodes you are using.

But if you google that error code and node.js you see that there are lots of posts about it.
Most recent ones appear to be with people using the MySQL user name 'root" if you are have you tried using a different username?

Otherwise, have you made sure you are on the latest versions of Node-RED and the SQL node?

If none of those work, then you will need to configure your MySQL server to allow a different access method.