I'm trying to connect to my MongoDB using MySQL through mongosqld. I have mongosqld running with a config file that looks like
security:
enabled: true
mongodb:
net:
uri: test-db
auth:
username: usertest
password: pass
source: admin
schema:
path: schema.drdl
I have it hosted on a [mongo ODBC manager](https://github.com/mongodb/mongo-odbc-driver/releases/) with
SERVER=127.0.0.1
, PORT=3071
, DATABASE=test_db
, UID=usertest?source=admin
, PWD=pass
. I am able to connect to and query this MongoDB through Excel using [Mongo's tutorial for that](https://docs.mongodb.com/bi-connector/current/connect/excel/) , but I am not able to do the same with MySQL using [Mongo's tutorial](https://docs.mongodb.com/bi-connector/current/connect/mysql/) . When I try to connect from terminal with mysql 'user=usertest?source=admin' --default-auth=mongosql_auth -p
I get ERROR 1045 (28000): Access denied for user 'usertest' and
handshake error: unable to saslStart conversation 0: Authentication failed.` from the mongosqld side. I am doing this on macOS. What could be causing this problem only for trying to connect from MySQL?
Asked by TheStrangeQuark
(101 rep)
Oct 8, 2018, 04:09 PM
Last activity: Aug 5, 2025, 04:04 AM
Last activity: Aug 5, 2025, 04:04 AM