mongodb查询

查询语句

db.tablename.find(查询语句):

• {"keys":/value.*/} 包含value字符
• {"keys":/.value.*/} value前面必须有字符
• {"keys":/^value/} 必须以value开头
• {"keys":{$ne:null} } 不为空
  

创建用户

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

只读账号
db.createUser(
...     {
...       user: "zjyr",
...       pwd: "zjyr",
...       roles: [
...          { role: "read", db: "test" }    #只读帐号
...       ]
...     }
... )

读写账号
db.createUser(
...     {
...       user: "test",
...       pwd: "test",
...       roles: [
...          { role: "readWrite", db: "auth_db" }   #读写帐号
...       ]
...     }
... )


超级账号
db.createUser(
...  {
...    user: "zhoujinyi",
...    pwd: "zhoujinyi",
...    roles: [
...       { role: "root", db: "admin" }      #超级root帐号
...    ]
...  }
... )

db.createUser(
...  {
...    user: "dxy",
...    pwd: "dxy",
...    roles: [
...       { role: "readWrite", db: "test" },     #在当前库下创建其他库的帐号，在admin库下创建test、abc库的帐号
...       { role: "readWrite", db: "abc" }         
...    ]
...  }
... )


查看当前用户的权限
use mydb
db.runCommand(
  {
    usersInfo:"userName",
    showPrivileges:true
  }
)


创建一个不受访问限制的超级用户
use admin
db.createUser(
  {
    user:"superuser",
    pwd:"pwd",
    roles:["root"]
  }
)


修改密码
use admin
db.changeUserPassword("username", "xxx")


查看用户信息
db.runCommand({usersInfo:"userName"})

修改密码和用户信息
db.runCommand(
  {
    updateUser:"username",
    pwd:"xxx",
    customData:{title:"xxx"}
  }
)

登录

mongo -u adminUserName -p userPassword --authenticationDatabase admin