MongoDB – Specify Authentication and Target Database Separately in Connection URI

mongodbmongodb-3.4

I am using this connection uri to connect to mongodb: mongodb://user:password@localhost/admin. It will use admin as bot authentication and target database. How can I make the uri to use admin as authentication but allow me to connect to a different database? Please see below command as an example:

mongo --host localhost -u user -p password --authentication admin test

the above command will use admin as the authentcation database but connect to test database. how can I do the same thing on uri?

Best Answer

Yes.. Easily!

mongo "mongodb://test:testpwd@localhost/test?authSource=admin"
MongoDB shell version v3.4.6
connecting to: mongodb://test:testpwd@localhost/test?authSource=admin
MongoDB server version: 3.4.6
MongoDB> db
test
MongoDB>

You put your destination DB at end of "base" string and add authentication db to parameter authSource

Work Arround

I used PuTTY to connect to the gear and form there I could connect to the mongo shell, and thus solved the issue.

Some Articles that might be helpfull to others.

Mongodb – Mongo Create a user as admin for any database raise an error

The '...AnyDatabase' roles should be added to the admin database for the user:

use admin
db.createUser({ user: "mongoadmin" , pwd: "mongoadmin", roles: ["userAdminAnyDatabase", "dbAdminAnyDatabase", "readWriteAnyDatabase"]})

Any database:

Database User Roles
Database Administration Roles

Admin database:

Cluster Administration Roles
Backup and Restoration Roles
All-Database Roles

Extra: To give different roles on different database and admin:

db.createUser({user:"replSetManager",pwd:"password",roles:[{role:"clusterManager",db:"admin"},{role:"dbOwner", db:"adminsblog"},{role:"readWrite", db:"departmentblog"},{role:"read", db:"otherblog"}]})

Best Answer

Related Solutions

Mongodb – Connect to Mongo Shell on OpenShift

Work Arround

Mongodb – Mongo Create a user as admin for any database raise an error

Related Question