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/