1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Access denied when connecting to mongosqld with mysql

Discussion in 'Programming/Internet' started by TheStrangeQuark, Oct 8, 2018.

  1. 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 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, but I am not able to do the same with mysql using Mongo's tutorial. 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' andhandshake error: unable to saslStart conversation 0: Authentication failed.` from the mongosqld side. I am doing this on OSX. What could be causing this problem only for trying to connect from mysql?

    Login To add answer/comment
     

Share This Page