Vfrdtyky

I am trying to upgrade my sandbox database server version to 4.x.x. It is now at 3.6.6

In order to do that, I need to create an admin user.

So I connect to the mongo shell and I run the following :

db.createUser( { user: "admin", pwd: "password", roles: [ { role: "root", db: "mydatabasename" } ] } );

However, I get the following error :

Error: couldn't add user: not authorized on admin to execute command 

It's been hours I am trying to figure out this issue. Other stackoverflow related questions don't solve it.

I am wondering if it is even possible to do so on a non dedicated database server. If not, how can I upgrade the server version ?

Any help would be greatly appreciated.

If this is first ever user you're trying to connect in DB, you need to use "Localhost Exception":

The localhost exception allows you to enable access control and then
create the first user in the system. With the localhost exception,
after you enable access control, connect to the localhost interface
and create the first user in the admin database. The first user must
have privileges to create other users, such as a user with the
userAdmin or userAdminAnyDatabase role

Create a user as follows:

use admin;

db.createUser( { user: "userAdminAnyDB", pwd: "password", roles: [ { role: "userAdminAnyDatabase", db: "admin" } ] } );



db.auth("userAdminAnyDB", "password")

Once you successfully login using userAdminAnyDB credentials, create a required for your Db deployment.

db.createUser( { user: "admin", pwd: "password", roles: [ { role: "root", db: "mydatabasename" } ] } );