MongoDB common command

目录

1. Show all existed db

2. Show all existed users

3. Show user's roles

4. View current db name

5. Create or Switch db

6. Grant privilege for a user

6.1. Common user

6.2. Admin user

6.3. Append privilege for Mongodb compass

7. Set a collection in one db

8. Show all roles

9. Show specific role's privilege

---

1. Show all existed db

> show dbs;

Note: If your db is empty, this command won't show the db.

2. Show all existed users

> db.getUsers();

3. Show user's roles

> db.getUsers("${userName}").roles;

4. View current db name

> db;

5. Create or Switch db

> use ${your_db_name};

6. Grant privilege for a user

6.1. Common user

> db.createUser({ user: '${userName}', pwd: '${password}', roles: [{ role: 'readWrite', db:'${db_name}'}]});

6.2. Admin user

> db.createUser({ user: '${userName}', pwd: '${password}', roles: [{ role: 'root', db:'${db_name}'}]});

6.3. Append privilege for Mongodb compass

> use ${target_db_name};

> db.grantRolesToUser( "${target_user_name}", [ {role:"clusterMonitor",db:"admin"} ]);

If you don't set the above permission, the client connection tool like "Mongodb compass" will occur error. 

7. Set a collection in one db

> db.${my_db_name}.insertOne({name: "John"})

8. Show all roles

> db.getRoles()

9. Show specific role's privilege

> db.getRole("readWrite")