Node-Red & MySql connection failed ( authentication protocol )

#1

Hi everyone! At first, I have a Simatic IOT2040 on which is running the Node-Red server. I want to make a MySql connection with my localhost server from my PC. To be able to access my external database, I have created a new user granting all privileges ( CREATE USER 'monty'@'%' IDENTIFIED BY '';
GRANT ALL PRIVILEGES ON . TO 'monty'@'%' WITH GRANT OPTION; ).
image
The host which I use is my Ip-adress of my Pc on which is running the server. But almost I cant connect to my DB.
errormsg
I know this is a MySql issue, but if somebody knows the solution please share with me. :smiley:
I tried to figure out how to upgrade my MySql client, but I did not find anything useful.

0 Likes

#2

google: ER_NOT_SUPPORTED_AUTH_MODE

Your database is not setup to login without a password.

1 Like

#3

Try

ALTER USER 'monty'@'%' IDENTIFIED WITH mysql_native_password BY 'thepassword';
1 Like

#4

Thank you very much . It works now.

0 Likes

#5

Which solution worked?

0 Likes

#6

I had to add a password for the db user! Thanks again !

0 Likes