By default there is only 1 user created during the installation process of BVQ (default name: bvq, role: root). You can modify the user & password in the repository installer within the DB access screen.
...
Establish a connection to MongoDB via mongo CLI (use CMD or PowerShell) (see https://docs.mongodb.com/v3.4/reference/program/mongo/)
No Format mongo --authenticationDatabase adminmongosh -u bvq -p P@ssw0rd
(default location of binaries = C:\Program Files\SVA\BVQ\bvq-mongodb\bin, put in PATH variable to access from outside the directory
change username -u and password -p to your credentials)
...
Establish a connection to MongoDB via mongo CLI (see Connect to MongoDB with mongo CLI)
The user information is configured globally for the entire MongoDB within the
admin
DB, so you have to switch to this DB.
List existing dbs withshow dbs
commandNo Format PS C:\Users\XXX> mongo --authenticationDatabase admin -u bvq -p P@ssw0rd MongoDB shell version v3.4.4 connecting to: mongodb://127.0.0.1:27017 MongoDB server version: 3.4.4 > show dbs admin 0.000GB bvq 0.401GB local 0.000GB
Switch to admin db with
use admin
No Format > use admin switched to db admin
Use
db.changeUserPassword()
to change the password for the user logged in (see https://docs.mongodb.com/v3.4/reference/method/db.changeUserPassword/)No Format db.changeUserPassword("bvq", "NEW_PASSWORD")
In this example password is changed to
NEW_PASSWORD
for userbvq
After executing this command the password will be changed
No Format PS C:\Users\XXX> mongo --authenticationDatabase admin -u bvq -p P@ssw0rd MongoDB shell version v3.4.4 connecting to: mongodb://127.0.0.1:27017 MongoDB server version: 3.4.4 2017-12-05T18:50:07.771+0100 E QUERY [thread1] Error: Authentication failed. : DB.prototype._authOrThrow@src/mongo/shell/db.js:1459:20 @(auth):6:1 @(auth):1:2 exception: login failed PS C:\Users\fschenke> mongo --authenticationDatabase admin -u bvq -p NEW_PASSWORD MongoDB shell version v3.4.4 connecting to: mongodb://127.0.0.1:27017 MongoDB server version: 3.4.4 > exit bye PS C:\Users\XXX>
...
- Establish a connection to MongoDB via mongo CLI (see Connect to MongoDB with mongo CLI)
Switch to admin db with
use admin
No Format > use admin switched to db admin
Use
db.getUsers()
to list existing users (see https://docs.mongodb.com/v3.4/reference/method/db.getUsers/)No Format > db.getUsers() [ { "_id" : "admin.bvq", "user" : "bvq", "db" : "admin", "roles" : [ { "role" : "root", "db" : "admin" } ] } ]
See https://docs.mongodb.com/v3.4/core/security-built-in-roles/ for available roles in MongoDB
...
Create a user
- Establish a connection to MongoDB via mongo CLI (see Connect to MongoDB with mongo CLI)
- Switch to admin db with
use admin
Use
db.createUser()
to create a new user (see https://docs.mongodb.com/v3.4/reference/method/db.createUser/)No Format > db.createUser({user: 'TEST_USER', pwd: 'TEST_PASSWORD', customData: { name: 'NAME OF TESTUSER' }, roles: ['readWriteAnyDatabase']}) Successfully added user: { "user" : "TEST_USER", "customData" : { "name" : "NAME OF TESTUSER" }, "roles" : [ "readWriteAnyDatabase" ] } >
(see https://docs.mongodb.com/v3.4/core/security-built-in-roles/ for available roles in MongoDB)
List users with
db.getUsers()
(see List existing users)No Format > db.getUsers() [ { "_id" : "admin.TEST_USER", "user" : "TEST_USER", "db" : "admin", "customData" : { "name" : "NAME OF TESTUSER" }, "roles" : [ { "role" : "readWriteAnyDatabase", "db" : "admin" } ] }, { "_id" : "admin.bvq", "user" : "bvq", "db" : "admin", "roles" : [ { "role" : "root", "db" : "admin" } ] } ] >
Remove
...
a user
- Establish a connection to MongoDB via mongo CLI (see Connect to MongoDB with mongo CLI)
Switch to admin db with
use admin
Use
db.dropUser()
to delete an existing user (see https://docs.mongodb.com/v3.4/reference/method/db.dropUser/)No Format > db.dropUser('TEST_USER') true >
List users with
db.getUsers()
(see List existing users)No Format > db.getUsers() [ { "_id" : "admin.bvq", "user" : "bvq", "db" : "admin", "roles" : [ { "role" : "root", "db" : "admin" } ] } ] >
User
TEST_USER
was deleted successfully (user was created in Create an additional user)