MongoDb: How to drop a database using shell using authentication?

Question

I have a authenticated user with all required privileges to drop a database. I want to drop the database from the shell and tried following command

mongo -uuser -ppass newdb --eval "db.dropDatabase();"

I got following:-

MongoDB shell version: 2.4.9
connecting to: newdb
[object Object]

That's it I got no errors and no results. The database still exists with all values.

Currently you would be on the "test" database unless you specified something else to connect to. Also you don't state an error or what happened/didn't happen in your question. — Neil Lunn
– Neil Lunn, Commented Mar 21, 2014 at 6:41

Roberto · Accepted Answer · 2014-03-21 07:41:17Z

2

Your command should work

mongo -uuser -ppass newdb --eval "db.dropDatabase();"

If you access to mongo after that with

mongo -uuser -ppass newdb

The database is created again but empty, so when you said:

The database still exists with all values.

Are you sure that has all collections inside ?

To check if has been deleted you can do:

mongo -uuser -ppass
> show dbs

The "newdb" shouldn't appear.

I've tested it with Mongo 2.4.2.

answered Mar 21, 2014 at 7:41

Roberto

9,1804 gold badges46 silver badges57 bronze badges

Sign up to request clarification or add additional context in comments.

6 Comments

Ehsan Sarshar Over a year ago

what is uuser is it a typo of user ?

Roberto Over a year ago

No, the first "u" is the command param -u , i.e: mongo -ujohn -pjohn_pass

Ehsan Sarshar Over a year ago

using -u user is invalid ?

Roberto Over a year ago

No, you can pass the param in both ways (with and without whie-space). I use this format in my answer because is the format used in the original question.

Ehsan Sarshar Over a year ago

I just test both case it still throw authentication error when using with eval

|

ZZY · Accepted Answer · 2014-03-21 06:51:35Z

1

You may try this:

mongo -u USER -p PASS --eval "db=db.getSiblingDB('DB_NAME');db.dropDatabase();"

Reference: http://docs.mongodb.org/manual/tutorial/write-scripts-for-the-mongo-shell/

answered Mar 21, 2014 at 6:51

ZZY

3,9871 gold badge22 silver badges22 bronze badges

Collectives™ on Stack Overflow

MongoDb: How to drop a database using shell using authentication?

2 Answers 2

6 Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

6 Comments

Comments

Related