Wednesday, January 1, 2025

MongoDB useful commands

Installation:

mongod --config "D:\MongoDB\bin\mongod.cfg" --install

net start MongoDB

User control:

db.createUser({user: "Bkp",pwd: passwordPrompt(), roles: [ "readWriteAnyDatabase" ]})

db.revokeRolesFromUser("Bkp", [{role:"readWriteAnyDatabase", db:"admin"}])

db.grantRolesToUser("Bkp",[{role:"backup",db:"admin"}])

db.createUser({user: "BACKUP_USER",pwd: "BKP", roles: [ "backup" ]})

db.dropUser("BACKUP_USER1")

db.createUser({user: "BACKUP_USER1",pwd: "BKP", roles: [ "read" ]})

db.grantRolesToUser("BACKUP_USER1",[{role:"readWriteAnyDatabase"}])

db.auth('webdev', 'xxxxx')

db.runCommand({connectionStatus : 1})

db.runCommand({connectionStatus : 1,showPrivileges:true})


Replicaset

mongod --bind_ip 192.168.56.1 --port 27019 --replSet rs0 --dbpath D:\MongoDB\Replicaset\data1 --oplogSize 200 --logpath D:\MongoDB\Replicaset\log1\log1.txt

mongod --bind_ip 192.168.56.1 --port 27020 --replSet rs0 --dbpath D:\MongoDB\Replicaset\data2 --oplogSize 200 --logpath D:\MongoDB\Replicaset\log2\log2.txt

mongod --bind_ip 192.168.56.1 --port 27021 --replSet rs0 --dbpath D:\MongoDB\Replicaset\data3 --oplogSize 200 --logpath D:\MongoDB\Replicaset\log3\log3.txt


rconfig={

_id:"rs0",

members:[

{_id:0,host:"192.168.56.1:27019"},

{_id:1,host:"192.168.56.1:27020"},

{_id:2,host:"192.168.56.1:27021"}]

}

rconfig

rs.initiate(rconfig)

rs.status()

rs.isMaster()


No comments:

Post a Comment

SQL Server TDE Database Encryption

This is Data-at-rest encryption. TDE is a feature that encrypts data files to protect them at rest. Databases to be encrypted: testdb, SAM 1...