MongoDb

Cheat sheet

Database Management

• Connect to a mongodb

mongo

• Display dabases

show dbs

• Connect to a database

use database

• List Tables (Collections)

show collections

• Create Collection

use formation
db.cours.insert({"titre":"MongoDB 101"})

• Remove Tables (Collections)

db.collection.drop()

• Remove Database (Collections)

db.dropDatabase()

• Statistics must be connected to database

db.stats()

User Management

• Create Admin user

use admin
db.createUser(
   {
     user: "userName",
     pwd:  "passWord",
     roles: [ { role: "userAdminAnyDatabase", db: "admin" }, "readWriteAnyDatabase" ]
   }
)

• Remove user

use admin
db.dropUser("userName")

• Change user Password

db.changeUserPassword("username:", "newPassWord")

• Login

mongo -u userName -p passWord --authenticationDatabase admin

or 

mongo admin -u 'userName' -p 'passWord'

or 
mongo
use admin
db.auth("userName", "passWord")

Import /export

• Import

mongoimport --db toDb --collection toCollection --drop -u userName -p passWord --authenticationDatabase admin --file /home/userName/fileToImport.json

Read Data

• Display content of a table

db.collection.find()
db.collection.find().limit(x)
db.collection.find().limit(x).pretty

Database Engine Management

• Stop Database

db.adminCommand( { shutdown: 1} )

Http Interface

Inable Http Interface

add http.enabled: true in /etc/mongod.conf

net:
  port: 27017
  bindIp: 127.0.0.1
  http.enabled: true
  http.RESTInterfaceEnabled: true

Access to htps interface

Http Interface

GUI Tool

• Robo 3T