show dbs gives Not Authorized to execute command error

Question

I ve spent some time trying to figure out what is wrong but as I could not find out  I decided to ask here   I am running MongoDB Windows 64-bit 2008 R2   version 3 2 3 on Windows 8  the paths are    C  MongoDB bin for the installation  C  data db for the data folder  I ve installed following this video and this tutorial from the official documentation   The first issue might be  as I don t really know if it is an issue at all  the connection between the client mongo exe  and the server mongod exe    I lauched mongod exe via the command line  with administrator rights   everything went fine  I got the message    waiting for connections on port 27017   but when I launch mongo exe via a new instance of the command line  the server mongod exe  doesn t print a message saying there is a new connection  it was the case in the tutorials I watched   On the other side  mongo exe prints   connecting to   test   I don t know if everything is correct at this point but I still tried some basics commands like    show dbs returns not authorized on admin to execute command  Basically  all the commands I tried had the same error message  even with  fresh  db I just created with use  dbName   Some answers online said I have to create a user with proper roles  I tried this one  Still the same error message not authorized to execute command  My question is the following    Is is normal that mongod exe doesn t show a new connection when I launch mongo exe   If it is correct then what can I do to make even the basic commands work    Additional Informations    I tried to uninstall re-install few times  with the  Custom mode  and the  Complete mode  in the Windows installer but it always lead to the same problem   I also tried to create a MongoDB Service following the official documentation but I m not really sure if it was a good idea   I can t add more links but it is in a section in the second link I shared   Edit section    I decided to try it on another computer which I have not touched for years  running on Windows 7 64-bit   I copied the MongoDB installation folder at the root of this computer  created  data db folder and launched mongod exe   Then I launched mongo exe and this time  mongod exe printed a message saying there is a new open connection which it doesn t on my actual computer  I think the problem is here because I was able to start the basic tutorial from the official documentation and perform simple commands like create a new db  insert  find  show dbs  etc  Everything that I am not able to do on my actual computer   So I think the problem is coming from the connection between mongod exe and mongo exe  Do you have any idea how I could solve this problem as I have tried uninstalling few times

User · Answer

It was Docker running in the background in my case  If you have Docker installed  you may wanna close it and try again

User · Answer

for me it worked by adding  1   You can run the mongodb instance without username and password first ---OK  2   Then you can add the user to the system database of the mongodb which is default one using the query below  ---OK  db createUser     user   myUserAdmin     pwd   abc123     roles      role   userAdminAnyDatabase   db   admin         mechanisms    SCRAM-SHA-1       I added this line

User · Answer

There are two things   1  You can run the mongodb instance without username and password first   2  Then you can add the user to the system database of the mongodb which is default one using the query below   db createUser     user   myUserAdmin     pwd   abc123     roles      role   userAdminAnyDatabase   db   admin           Thanks

User · Answer

Copy of answer OP posted in question   Solution  After the update from the previous edit  I looked a bit about the connection between client and server and I found out that even when mongod exe was not running  there was still something listening on port 27017 with netstat -a  So I tried to launch the server with a random port using    dir mongod exe --port 2000   Then the shell with   dir mongo exe --port 2000   And this time  the server printed a message saying there is a new connection  I typed few commands and everything was working perfectly fine  I started the basic tutorial from the documentation to check if it was ok and for now it is

User · Answer

Create a user like this   db createUser                  user   myUserAdmin           pwd   abc123           roles      role   userAdminAnyDatabase   db   admin                      Then connect it following this   mongo --port 27017 -u  myUserAdmin  -p  abc123  --authenticationDatabase  admin    Check the manual        https   docs mongodb org manual tutorial enable-authentication

User · Answer

You should have started the mongod instance with access control  i e   the --auth command line option  such as     mongod --auth   Let s start the mongo shell  and create an administrator in the admin database     mongo  gt  use admin  gt  db createUser          user   myUserAdmin       pwd   abc123       roles      role   userAdminAnyDatabase   db   admin              Now if you run command  db stats     or  show users   you will get error  not authorized on admin to execute command       gt  db stats              ok    0           errmsg     not authorized on admin to execute command   dbstats  1 0  scale  undefined              code    13           codeName     Unauthorized      The reason is that you still have not granted role  read  or  readWrite  to user myUserAdmin  You can do it as below    gt  db auth  myUserAdmin    abc123    gt  db grantRolesToUser  myUserAdmin       role   read   db   admin         Now You can verify it  Command  show users  now works     gt  show users             id     admin myUserAdmin            user     myUserAdmin            db     admin            roles                                                 role     read                            db     admin                                                                role     userAdminAnyDatabase                            db     admin                                  Now if you run  db stats     you ll also be OK    gt  db stats              db     admin            collections    2           views    0           objects    3           avgObjSize    151           dataSize    453           storageSize    65536           numExtents    0           indexes    3           indexSize    81920           ok    1     This user and role mechanism can be applied to any other databases in MongoDB as well  in addition to the admin database    MongoDB version 3 4 3

User · Answer

one more  after you create user by following cmd-1  please assign read write root role to the user by cmd-2  then restart mongodb by cmd  mongod --auth     The benefit of assign role to the user is you can do read write operation by mongo shell or python java and so on  otherwise you will meet  pymongo errors OperationFailure  not authorized  when you try to read write your db   cmd-1   use admin db createUser     user   newUsername     pwd   password     roles      role   userAdminAnyDatabase   db   admin           cmd-2   db grantRolesToUser  newUsername     role   root   db   admin

[mongodb] show dbs gives "Not Authorized to execute command" error

Examples related to mongodb