Команды

CREATE USER {{user}} WITH PASSWORD '{{password}}';

CREATE USER '{{user}}'@'%' IDENTIFIED BY '{{password}}';

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

ACL SETUSER {{user}} on >{{password}} ~* +@all

CREATE DATABASE {{dbname}} OWNER {{user}};

CREATE DATABASE {{dbname}};

use {{dbname}}

# Redis не использует базы как SQL (логические DB 0-15)

GRANT ALL PRIVILEGES ON DATABASE {{dbname}} TO {{user}};

GRANT ALL PRIVILEGES ON {{dbname}}.* TO '{{user}}'@'%';
FLUSH PRIVILEGES;

db.grantRolesToUser("{{user}}", [
  { role: "dbOwner", db: "{{dbname}}" }
])

ACL SETUSER {{user}} on >{{password}} ~* +@all

REVOKE ALL PRIVILEGES ON DATABASE {{dbname}} FROM {{user}};

REVOKE ALL PRIVILEGES ON {{dbname}}.* FROM '{{user}}'@'%';
FLUSH PRIVILEGES;

db.revokeRolesFromUser("{{user}}", [
  { role: "dbOwner", db: "{{dbname}}" }
])

ACL SETUSER {{user}} off

DROP USER {{user}};

DROP USER '{{user}}'@'%';

db.dropUser("{{user}}")

ACL DELUSER {{user}}

DROP DATABASE {{dbname}};

DROP DATABASE {{dbname}};

use {{dbname}}
db.dropDatabase()

# Redis: не применяется

ALTER USER {{user}} WITH PASSWORD '{{newpassword}}';

ALTER USER '{{user}}'@'%' IDENTIFIED BY '{{newpassword}}';

db.changeUserPassword("{{user}}", "{{newpassword}}")

ACL SETUSER {{user}} >{{newpassword}}