command line authentication of mongo fails

Mongodb

Mongodb Problem Overview


I am running mongo 2.2.2 on osx.

When I do the following authentication is going fine:

$ mongo
>> use admin
>> db.auth("uname", "password")

log:

Thu Mar  7 13:51:08 [initandlisten] connection accepted from 127.0.0.1:63474 #10 (4 connections now open)
Thu Mar  7 13:51:08 [conn10]  authenticate db: admin { authenticate: 1, nonce: "123", user: "uname", key: "456" }

However when I try to authenticate directly from the commandline:

$ mongo admin -u uname -p password

I get the following error:

Thu Mar  7 14:25:52 [initandlisten] connection accepted from 127.0.0.1:63939 #12 (5 connections now open)
Thu Mar  7 14:25:52 [conn12]  authenticate db: admin { authenticate: 1, nonce: "789", user: "uname", key: "147" }
Thu Mar  7 14:25:52 [conn12] auth: key mismatch uname, ns:admin
Thu Mar  7 14:25:52 [conn12] end connection 127.0.0.1:63939 (4 connections now open)

Does anyone know what causes this?

Mongodb Solutions


Solution 1 - Mongodb

A password containing special characters, especially the dollar sign, has to be put in single quotes to protect them from the command shell:

$ mongo admin -u uname -p 'password'

Solution 2 - Mongodb

You have to use the --authenticationDatabase to indicate mongodb where to find the user you have created. For example:

mongo admin -u uname -p 'password' --authenticationDatabase admin

Solution 3 - Mongodb

This is the way to access an authenticate MongoDB database from terminal

mongo -u user_name -p "your_password" host_name/database_name

Ex:

mongo -u hasib -p "123456" localhost/my_db

Solution 4 - Mongodb

You could also connect using the mongo connection URL as follow:

mongo "mongodb://<user>:<password>@<host: 127.0.0.1>:<port: 27017>/<db_name>?authSource=admin"
  • The db_name is optional.
  • The host is usually 127.0.0.1 if you are connection to localhost.
  • The port is usually 27017.

Solution 5 - Mongodb

To Login to MongoDB Via Command Line do the following

$ mongo admin -u 'username' -p 'Password'

Attributions

All content for this solution is sourced from the original question on Stackoverflow.

The content on this page is licensed under the Attribution-ShareAlike 4.0 International (CC BY-SA 4.0) license.

Content TypeOriginal AuthorOriginal Content on Stackoverflow
QuestionRickyAView Question on Stackoverflow
Solution 1 - MongodbronastaView Answer on Stackoverflow
Solution 2 - Mongodbuser6155548View Answer on Stackoverflow
Solution 3 - MongodbHasib Kamal ChowdhuryView Answer on Stackoverflow
Solution 4 - Mongodbkimy82View Answer on Stackoverflow
Solution 5 - MongodbPrashanth MuthurajaiahView Answer on Stackoverflow