MongoDB Connection to WB (local)
I am trying to connect MongoDB living on a host machine on our network with WorkBench. I went through the steps advised by the MongoDB doc site saying I need to install a MongoDB ODBC driver (v1.2). Installed that and got it configured.
I have installed MongoDB Compass (client tool) and have successfully connected to the localhost MongoDB using no creds and port 27117. When I went in and tried to map them to Workbench the same way I kept on getting an error like the one below. I have attached a screenshot of how I set up the connection. Am I doing something wrong that the data does not connect and keeps erroring out?
ERROR [08S01] [MySQL][ODBC 1.2(w) Driver]Lost connection to MySQL server at 'waiting for initial communication packet', system error: 10060