Not able to connect MySQL server running on docker with Node-Red container
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 184.108.40.206 and MySQL port is 3306
Can some one tell me what I am doing wrong here. Thanks.