Solution :
You need to execute the below query in MYSQL Workbench
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password'
Where the root
is your user localhost
is your URL and password
is your password
Then run below query to refresh the privileges:
flush privileges;
After that you can try connecting using the node after you do so.
If that does not work then try it without @'localhost'
part.
OR
In your Mysql Latest docker container try to run below query
ALTER USER root IDENTIFIED WITH mysql_native_password BY 'password';
Hope the above listed solutions will fix your issue.