Not able to connect MySQL server running on docker with Node-Red container

Published

I have a VM (OS: Ubuntu 18.04) running in azure cloud in which I have installed docker. In docker I have two containers MySQL and node-red, I am trying to connect my MySQL with node-red and I get the following error message in Node-Red

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

MySQL is working fine, I am able to access the database via putty but somehow I am not able to make a successful connection with node-red as well as Grafana.

I am using following configuration. My VM’s IP address is 20.107.194.152 and MySQL port is 3306
[1][Node-red config]

Can some one tell me what I am doing wrong here. Thanks.

Source: Docker Questions

Published
Categorised as azure, docker, mysql, node-red, virtual-machine Tagged , , , ,

Answers

Leave a Reply

Still Have Questions?


Our dedicated development team is here for you!

We can help you find answers to your question for as low as 5$.

Contact Us
faq