Account Management SQL Commands

Don't see the content you are looking for above? Try these related English language items.

• 8

  CREATE USER

  Create new MariaDB accounts.
• 1

  ALTER USER

  Modify an existing MariaDB account.
• 1

  DROP USER

  Remove one or more MariaDB accounts.
• 6

  GRANT

  Create accounts and set privileges or roles.
• RENAME USER

  Rename user account.
• 4

  REVOKE

  Remove privileges or roles.
• SET PASSWORD

  Assign password to an existing MariaDB user.
• CREATE ROLE

  Add new roles.
• DROP ROLE

  Drop a role.
• 1

  SET ROLE

  Enable a role.
• 5

  SET DEFAULT ROLE

  Sets a default role for a specified (or current) user.
• 9

  SHOW GRANTS

  under: » MariaDB Server Documentation » Using MariaDB Server » SQL Statements & Structure » SQL Statements » Administrative SQL Statements » SHOW
  View GRANT statements.
• SHOW CREATE USER

  under: » MariaDB Server Documentation » Using MariaDB Server » SQL Statements & Structure » SQL Statements » Administrative SQL Statements » SHOW
  Show the CREATE USER statement that creates a specified user.