Create an account (MySQL database user)

Concepts

An account is a user with specific permissions, such as read, write, and management permissions for databases. In an OceanBase MySQL tenant, an account is a MySQL database user that can be associated with multiple databases. In contrast, an account in an Oracle tenant has permissions only for its corresponding schema. You can also assign multiple roles to each account to implement more fine-grained access control. An account can access multiple databases, and a single database can be accessed by multiple accounts. Each database belongs to a tenant, and each tenant can manage multiple databases. For more information, see Create an account.

Three types of accounts are supported: standard, super, and read-only. Create an account based on the required permissions.

• Standard account: Can perform operations on a database according to its granted permissions.

• Super account: Has read and write permissions for all databases by default.

• Read-only account: Has read permission for all databases by default.

Procedure

1. In the navigation pane on the left, click Account Management.

2. In the upper-right corner, click Create Account.

3. In the dialog box that appears, enter the following information:

   1. The username is admin_user.

   2. Set Account Type to Super Account.

   3. Click Generate Randomly to generate a password.

   4. Click Copy Password and record the password.

4. Click OK.