CREATE ACCOUNT

Description

Create a new account in your organization.

Syntax

1. > CREATE ACCOUNT  [IF NOT EXISTS]
2. account auth_option
3. [COMMENT 'comment_string']

5. auth_option: {
6. ADMIN_NAME [=] 'admin_name'
7. IDENTIFIED BY 'auth_string'
8. }

Explanations

auth_option

Specifies the default account name and authorization mode of the account, auth_string specifies the password explicitly.

Examples

1. > create account tenant_test admin_name = 'root' identified by '111' comment 'tenant_test';
2. Query OK, 0 rows affected (0.08 sec)