W3cubDocs

/MariaDB

Account Management SQL Commands

CREATE/DROP USER, GRANT, REVOKE, SET PASSWORD etc.

Title Description
CREATE USER Create new MariaDB accounts.
ALTER USER Modify an existing MariaDB account.
DROP USER Remove one or more MariaDB accounts.
GRANT Create accounts and set privileges or roles.
RENAME USER Rename user account.
REVOKE Remove privileges or roles.
SET PASSWORD Assign password to an existing MariaDB user.
CREATE ROLE Add new roles.
DROP ROLE Drop a role.
SET ROLE Enable a role.
SET DEFAULT ROLE Sets a default role for a specified (or current) user.
SHOW GRANTS View GRANT statements.
SHOW CREATE USER Show the CREATE USER statement for a specified user.
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.

© 2019 MariaDB
Licensed under the Creative Commons Attribution 3.0 Unported License and the GNU Free Documentation License.
https://mariadb.com/kb/en/account-management-sql-commands/