Error: couldn’t add user: not authorized on test to execute command { createUser:

Stop the running instance of mongod
mongod --config /usr/local/etc/mongod.conf --auth

then start without --auth like
mongod --config /usr/local/etc/mongod.conf

then update your roles like

db.updateUser(“admin”,{roles :
[“userAdminAnyDatabase”,”userAdmin”,”readWrite”,”dbAdmin”,”clusterAdmin”,”readWriteAnyDatabase”,”dbAdminAnyDatabase”]});

Now again start mongod with --auth and try.


The idea is you have to create user under “admin” database with all the ROLES mentioned above.

But this user is not part of other databases. So once you created the admin user,

then login as that admin user,

SERVER: mongod –config /usr/local/etc/mongod.conf –auth

CLIENT: ./mongodb/bin/mongo localhost:27017/admin -u adminUser -p
123456

use APPLICATION_DB

again create a new user (say APP_USER) for this APPLICATION_DB. This time for this application user you need only “dbOwner” role.

db.createUser({user:"test", pwd:"test", roles:['dbOwner']})

Now your application has to use this APP_USER and APP_DB.

Leave a Comment

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)