This topic describes how to create and delete a database sub-account, reset the database password, authorize a sub-account, and revoke permissions from the sub-account in Data Lake Analytics (DLA).

Create a database sub-account

  1. Log on to the DLA console.
  2. In the left-side navigation pane, click Account.
  3. On the Account page, click Create Child Account.
  4. In the Create Child Account panel, configure Username and Password.
    DLA allows you to set sub-account passwords in one of the following ways:
    • Random Password: DLA randomly generates a sub-account password. If you want to use a random password, select Use System-generated password and click OK. The system automatically generates a password.
    • Manually specified password: Enter the sub-account password and click OK.

Delete a database sub-account

  1. Log on to the DLA console.
  2. In the left-side navigation pane, click Account.
  3. On the Account page, find the sub-account that you want to delete, and click Delete in the Actions column.
  4. In the Confirm Delete message, click OK. After the system sends a verification code to the bound mobile phone, enter the verification code. Then, click OK to delete the database sub-account.

Reset the database password

If you forget the password of your database account when you use DLA, you can reset the password in the DLA console.

Note We recommend that you change your password on a regular basis to ensure data security.
  1. Log on to the DLA console.
  2. In the left-side navigation pane, click Account.
  3. On the Account page, find the account whose password you want to reset, and click Reset Password in the Actions column.
  4. In the Reset Password panel, specify a new password for the account.
    DLA allows you to set sub-account passwords in one of the following ways:
    • Random Password: DLA randomly generates a sub-account password. If you want to use a random password, select Use System-generated password and click OK. The system automatically generates a password.
    • Manually specified password: Enter the sub-account password and click OK.
  5. In the mobile phone verification box, enter the verification code, and click OK.

If you change the password of the root account, DLA sends you a notification about the password change. If you forget the password of the root account, you can retrieve the password from the notification.

Authorize a database sub-account

You can grant permissions to a database sub-account by using the root account in the following ways:
  • Log on to the DLA console. In the left-side navigation pane, choose Serverless Presto > Execute. On the page that appears, execute the GRANT statement by using the root account in the code editor to grant permissions to the sub-account.
  • In the application, use program code, MySQL CLI tool, or MySQL client to connect to DLA by using the root account, and execute the GRANT statement to grant permissions to the sub-account.

Revoke permissions from a database sub-account

Only the root account can be used to revoke permissions from a database sub-account. For more information about how to revoke permissions from a sub-account, see REVOKE.