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; ).
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.
I know this is a MySql issue, but if somebody knows the solution please share with me.
I tried to figure out how to upgrade my MySql client, but I did not find anything useful.
google: ER_NOT_SUPPORTED_AUTH_MODE
Your database is not setup to login without a password.
Try
ALTER USER 'monty'@'%' IDENTIFIED WITH mysql_native_password BY 'thepassword';
Thank you very much . It works now.
Which solution worked?
I had to add a password for the db user! Thanks again !