mongodb操作使用

[root@lijia1 mongodb3222]# mkdir -p /var/lib/mongo

[root@lijia1 mongodb3222]# mkdir -p /var/log/mongodb

vi /etc/profile
export MONGODB_HOME=/opt/bigdata/mongodb3222
export PATH=$PATH:$MONGODB_HOME/bin

[root@lijia1 mongodb3222]# mongod --dbpath /var/lib/mongo --logpath /var/log/mongod.log --fork

[root@lijia1 mongodb3222]# mongo

默认是test数据库
查看当前数据库：
db

切换数据库
use kb07
use admin

查看数据库中的表
show tables

在表中插入数据
db.runoob.insert({x:10})

删除runoob表
db.runoob.drop()

查看当前库中的用户
show users

给数据库kb07创建用户

db.createUser({user:“gree”,pwd:“gree”,roles:[{role:“readWrite”, db:“kb07”}]})
Successfully added user: {
“user” : “gree”,
“roles” : [
{
“role” : “readWrite”,
“db” : “kb07”
}
]
}

创建用户

use admin
switched to db admin

db.createUser({user:“dba”,pwd:“dba”, roles: [ { role: “userAdminAnyDatabase”, db: “admin” } ]})

db.auth(‘dba’,‘dba’)
1

show users
{
“_id” : “admin.dba”,
“user” : “dba”,
“db” : “admin”,
“roles” : [
{
“role” : “userAdminAnyDatabase”,
“db” : “admin”
}
]
}

show dbs
admin 0.078GB
kb05 0.078GB
local 0.078GB
test 0.078GB

db.createUser({user:“gree”,pwd:“gree”,roles:[{role:“readWrite”,db:“kb05”}]})
Successfully added user: {
“user” : “gree”,
“roles” : [
{
“role” : “readWrite”,
“db” : “kb05”
}
]
}

2+2
4
db
test
show dbs
local 0.078GB
use admin
switched to db admin
db.createUser(
… {
… user:“dba”,
… pwd:“dba”,
… roles:[ { role: “userAdminAnyDatabase”, db: “admin” }]
… }
… )
Successfully added user: {
“user” : “dba”,
“roles” : [
{
“role” : “userAdminAnyDatabase”,
“db” : “admin”
}
]
}
^C
bye
[root@lijia1 bin]# mongo
MongoDB shell version: 3.0.6
connecting to: test
show dbs
2020-06-10T16:12:29.689+0800 E QUERY Error: listDatabases failed:{
“ok” : 0,
“errmsg” : “not authorized on admin to execute command { listDatabases: 1.0 }”,
“code” : 13
}
at Error ()
at Mongo.getDBs (src/mongo/shell/mongo.js:47:15)
at shellHelper.show (src/mongo/shell/utils.js:630:33)
at shellHelper (src/mongo/shell/utils.js:524:36)
at (shellhelp2):1:1 at src/mongo/shell/mongo.js:47
use admin
switched to db admin
db.auth(‘dba’,‘dba’)
1
ues test
2020-06-10T16:13:00.799+0800 E QUERY SyntaxError: Unexpected identifier
use test
switched to db test
db.createUser(
… {
… user:“test”,
… pwd:“test”,
… roles:[{role:“readWrite”, db:“test”}]
… }
… )
Successfully added user: {
“user” : “test”,
“roles” : [
{
“role” : “readWrite”,
“db” : “test”
}
]
}
^C
bye
[root@lijia1 bin]# mongo
MongoDB shell version: 3.0.6
connecting to: test
use test
switched to db test
db.auth(‘test’,‘test’)
1
db
test
db
test
show tables;
students
system.indexes

JAVA代码
public class MongoTest {
public static void main(String[] args) {
try {
ServerAddress serverAddress = new ServerAddress(“192.168.153.141”, 27017);
List addrs = new ArrayList<>();
addrs.add(serverAddress);

        MongoCredential credential = MongoCredential.createScramSha1Credential("test",
                "test","test".toCharArray());
        List<MongoCredential> credentials = new ArrayList<>();
        credentials.add(credential);

        MongoClient mongoClient = new MongoClient(addrs, credentials);

        final MongoDatabase test = mongoClient.getDatabase("test");
        System.out.println(test);

        test.createCollection("students");
        System.out.println("successfull");
    } catch (Exception e) {
        e.printStackTrace();
    }
}

}