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, Mar 21 '14 at 06:41

score 2 · Answer 1 · answered Mar 21 '14 at 07:41

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 '14 at 07:41

Roberto

what is uuser is it a typo of user ? – TheEhsanSarshar May 13 '20 at 09:18
No, the first "u" is the command param `-u` , i.e: `mongo -ujohn -pjohn_pass` – Roberto May 13 '20 at 18:52
using -u user is invalid ? – TheEhsanSarshar May 14 '20 at 05:40
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. – Roberto May 14 '20 at 09:38
I just test both case it still throw authentication error when using with eval – TheEhsanSarshar May 14 '20 at 12:38
Ok, I'd need more context to be sure, but the problem is yout MongoDB config for auth, try to add this param `--authenticationDatabase=admin` before the dbname – Roberto May 14 '20 at 13:24

score 1 · Answer 2 · answered Mar 21 '14 at 06:51

1

You may try this:

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

answered Mar 21 '14 at 06:51

ZZY

2 Answers2