MongoDB之命令行 命令

xshell 登录到 MongoDB电脑

进入到目录下

[root@node127 console]# cd mongodb_common/
[root@node127 mongodb_common]# ls
bin
GNU-AGPL-3.0
journal
LICENSE-Community.txt
mongodb_common-1.3.4.0.9.1-linux.rhel.7.amd64-release.tar.gz
MPL-2
README
VERSION
[root@node127 mongodb_common]# cd bin/
[root@node127 bin]# ls
bsondump         mongod       mongofiles   mongorestore  mongotop
install_compass  mongodump    mongoimport  mongos
mongo            mongoexport  mongoreplay  mongostat

登录

[root@node127 bin]# ./mongo --port 27017
MongoDB shell version v4.0.9
connecting to: mongodb://127.0.0.1:27017/?gssapiServiceName=mongodb
Implicit session: session { "id" : UUID("233f49fd-be88-4de1-8368-3a17b8671dde") }
MongoDB server version: 4.0.9

进入 admin 数据库，然后认证 账号 密码

mongos> use admin
switched to db admin
mongos> db.auth('admin','admin!123')
1

创建用户和数据库，然后插入数据

mongos> db.createUser({user: "apple",pwd: "111111",roles: [ { role: "dbOwner", db: "autotest" } ]} )
Successfully added user: {
    "user" : "apple",
    "roles" : [
        {
            "role" : "dbOwner",
            "db" : "autotest"
        }
    ]
}

mongos> db.auth('apple','111111')
1
mongos> use autotest
switched to db autotest
mongos> db.city.insert({city_id: NumberLong("1"),city:"beijing"})
WriteResult({ "nInserted" : 1 })
mongos> db.city.insert({city_id: NumberLong("2"),city:"shanghai"})
WriteResult({ "nInserted" : 1 })

查询数据

mongos> db.city.find()
{ "_id" : ObjectId("5e7c4a3c89da5f03d4886442"), "city_id" : NumberLong(1), "city" : "beijing" }
{ "_id" : ObjectId("5e7c4b2989da5f03d4886443"), "city_id" : NumberLong(2), "city" : "shanghai" }

删除数据

db.city.remove({});
WriteResult({ "nRemoved" : 4 })

附录

几种登录方式

1.无密码登陆本机部署的mongos路由服务 ，端口为27017
mongo --port 27017

2.使用用户名密码登陆
/mongodb_common/bin/mongo --port 27017 -uadmin -padmin12345

3.登陆远程主机
./mongo 142.16.122.71:27017/admin -uadmin -padmin12345

解析：142.16.122.71:27017为主机名（IP）、端口。admin 为登陆的数据库

进入bin目录

[root@node127 bin]# ls
bsondump         mongo   mongodump    mongofiles   mongoreplay   mongos     mongotop
install_compass  mongod  mongoexport  mongoimport  mongorestore  mongostat

无密码登录本机部署的mongos路由服务

[root@node127 bin]# ./mongo --port 27017
MongoDB shell version v4.0.9
connecting to: mongodb://127.0.0.1:27017/?gssapiServiceName=mongodb
Implicit session: session { "id" : UUID("648db192-0bb0-4737-83e4-ba6187c9971b") }
MongoDB server version: 4.0.9
mongos>

切换数据库，数据库：admin。然后输入账号密码

mongos> use admin
switched to db admin
mongos> db.auth('admin','admin!123')
1
mongos>