FilesExpand file tree

master

/

Enable_Authentication_on_MongoDB.sql

Copy path

Blame

More file actions

Blame

More file actions

Latest commit

 

History

History

History

159 lines (147 loc) · 4.78 KB

master

/

Enable_Authentication_on_MongoDB.sql

Copy path

Top

File metadata and controls

• Code
• Blame

159 lines (147 loc) · 4.78 KB

Raw

Copy raw file

Download raw file

Open symbols panel

Edit and raw actions

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

33

34

35

36

37

38

39

40

41

42

43

44

45

46

47

48

49

50

51

52

53

54

55

56

57

58

59

60

61

62

63

64

65

66

67

68

69

70

71

72

73

74

75

76

77

78

79

80

81

82

83

84

85

86

87

88

89

90

91

92

93

94

95

96

97

98

99

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

128

129

130

131

132

133

134

135

136

137

138

139

140

141

142

143

144

145

146

147

148

149

150

151

152

153

154

155

156

157

158

159

-- Steps to Create and Drop Users in MongoDB

[root@localhost /]# mongo

> show dbs

/*

admin 0.000GB

config 0.000GB

local 0.000GB

*/

> use admin

/*

switched to db admin

*/

-- To create user with admin privileges in your MongoDB server.

> db.createUser(

... {

... user:"admin",

... pwd:"Admin@P@55w0rd",

... roles:[{role:"root",db:"admin"}]

... }

... )

/*

Successfully added user: {

"user" : "admin",

"roles" : [

{

"role" : "root",

"db" : "admin"

}

]

}

*/

> db.getUsers()

/*

[

{

"_id" : "admin.admin",

"userId" : UUID("fb8f44e9-54b9-4dcc-b08f-27d3537311e5"),

"user" : "admin",

"db" : "admin",

"roles" : [

{

"role" : "root",

"db" : "admin"

}

],

"mechanisms" : [

"SCRAM-SHA-1",

"SCRAM-SHA-256"

]

}

]

*/

> db.auth('admin','Admin@P@55w0rd')

/*

1

*/

--To Add User for Database

/*

To create database specific users, that user will have access to that database only.

You can also specify access level for that user on database.

For example we are creating a user account with read write access on mydb database.

*/

> use chatbox

/*

switched to db mydb

*/

> db.createCollection("test")

/*

{ "ok" : 1 }

*/

> db.createUser(

... {

... user: "chatbox",

... pwd: "Ch@tB0x@P@55w0rd",

... roles: ["readWrite"]

... }

... )

/*

Successfully added user: { "user" : "mongodbuser", "roles" : [ "readWrite" ] }

*/

> db.auth('chatbox','Ch@tB0x@P@55w0rd')

/*

1

*/

> db.getUsers()

/*

[

{

"_id" : "chatbox.chatbox",

"userId" : UUID("9136a557-1271-44ee-bd67-b8c4ec0daa48"),

"user" : "chatbox",

"db" : "chatbox",

"roles" : [

{

"role" : "readWrite",

"db" : "chatbox"

}

],

"mechanisms" : [

"SCRAM-SHA-1",

"SCRAM-SHA-256"

]

}

]

*/

> exit

/*

bye

*/

[root@localhost ~]# systemctl stop mongod

[root@localhost ~]# vi /etc/mongod.conf

/*

#security:

security.authorization: enabled

*/

[root@localhost ~]# systemctl start mongod

[root@localhost ~]# systemctl status mongod

sudo service mongodb restart

/*

? mongod.service - MongoDB Database Server

Loaded: loaded (/usr/lib/systemd/system/mongod.service; enabled; vendor preset: disabled)

Active: active (running) since Thu 2019-05-09 22:46:23 +0545; 7s ago

Docs: https://docs.mongodb.org/manual

Process: 12579 ExecStart=/usr/bin/mongod $OPTIONS (code=exited, status=0/SUCCESS)

Process: 12577 ExecStartPre=/usr/bin/chmod 0755 /var/run/mongodb (code=exited, status=0/SUCCESS)

Process: 12575 ExecStartPre=/usr/bin/chown mongod:mongod /var/run/mongodb (code=exited, status=0/SUCCESS)

Process: 12574 ExecStartPre=/usr/bin/mkdir -p /var/run/mongodb (code=exited, status=0/SUCCESS)

Main PID: 12582 (mongod)

CGroup: /system.slice/mongod.service

+-12582 /usr/bin/mongod -f /etc/mongod.conf

May 09 22:46:22 localhost.localdomain systemd[1]: Starting MongoDB Database Server...

May 09 22:46:22 localhost.localdomain mongod[12579]: about to fork child process, waiting until server is ready for connections.

May 09 22:46:22 localhost.localdomain mongod[12579]: forked process: 12582

May 09 22:46:23 localhost.localdomain systemd[1]: Started MongoDB Database Server.

*/

[root@localhost ~]#mongo --host 127.0.0.1 --port 27017 -u admin -p Admin@P@55w0rd

--or

[root@localhost ~]#mongo --host 127.0.0.1 --port 27017 -u admin -p Admin@P@55w0rd --authenticationDatabase admin

[root@localhost ~]#mongo --host 127.0.0.1 --port 27017 -u chatbox -p Ch@tB0x@P@55w0rd --authenticationDatabase chatbox

--Backup

[root@localhost ~]# mkdir -p /home/BackUpMongoDB/MongoFullBackup/dump/

[root@localhost ~]# mongodump --host 127.0.0.1 --port 27017 -u admin -p Admin@P@55w0rd --authenticationDatabase admin --out /home/BackUpMongoDB/MongoFullBackup/dump/

--Restore

--FullBackupRestore

[root@localhost ~]#mongorestore --host 127.0.0.1:27017 -u admin -p Admin@P@55w0rd --authenticationDatabase admin /home/BackUpMongoDB/MongoFullBackup/dump/

--ParticularBackupRestore

[root@localhost ~]#mongorestore --host 127.0.0.1:27017 -u admin -p Admin@P@55w0rd --authenticationDatabase admin -d chatbox /home/BackUpMongoDB/MongoFullBackup/dump/chatbox