Database User Accounts for MariaDB Enterprise Server

Overview

With MariaDB Enterprise Server, you can create, alter, and drop database user accounts.

Create

To create a database user account with MariaDB Enterprise Server, use the CREATE USER statement:

CREATE USER 'USER'@'192.0.2.%'
   IDENTIFIED BY 'PASSWD';

Replace the referenced IP address with the relevant address for your environment.

Replace USER and PASSWD with appropriate credentials for the new user account.

Alter

To alter a database user account with MariaDB Enterprise Server, use the ALTER USER statement:

ALTER USER 'USER'@'192.0.2.%'
   IDENTIFIED BY 'PASSWD';

Drop

To drop a database user account with MariaDB Enterprise Server, use the DROP USER statement:

DROP USER 'USER'@'192.0.2.%';

Password Policies

When setting a database user account's password, please choose a password that meets your organization's password policies.

For additional information, see "Password Validation Plugins".