Help Center > > User Guide> GaussDB(for MySQL) DB Instance Management (Standard Edition)> User Management

User Management

Updated at: Sep 29, 2020 GMT+08:00

Scenarios

Multiple users with different permissions can be created to access a DB instance or database, but the permissions of these users cannot exceed the operation permissions of the account.

Prerequisites

You have logged in to a GaussDB(for MySQL) DB instance on the DAS console.

Procedure

  1. On the top menu bar, choose Other Operations > User Management.
  2. On the displayed page, click Create User. Then, configure required information, such as basic information, advanced settings, global permissions, and object permissions.

    • Add DAS IP Address: You can add the IP address segment where DAS locates to the whitelist of the user. This network segment is used by DAS only. Other services do not use this network segment to connect to databases.
    • Password: To ensure data security, the password must:
      • Contain 8 to 12 characters.
      • Be a strong password.
      • Be different from the username or the username spelled backwards.
      • Must contain at least three types of the following characters: uppercase letters, lowercase letters, digits, and special characters, including ~!@#%^*-_+=?

  3. Click Save. In the displayed SQL Preview dialog box, click OK.
  4. In the user management list, view, edit, or delete information about created users.

    • Search

      Enter a username in the search box in the upper right corner to query user information.

    • Edit

      On the displayed page, locate the target username and click Edit in the Operation column.

      On the displayed page, edit user information, set global and object permissions, and click Save. In the displayed dialog box, click OK.

    • Delete

      On the displayed page, locate the target user and click Delete in the Operation column. In the displayed dialog box, click Yes.

Did you find this page helpful?

Submit successfully!

Thank you for your feedback. Your feedback helps make our documentation better.

Failed to submit the feedback. Please try again later.

Which of the following issues have you encountered?







Please complete at least one feedback item.

Content most length 200 character

Content is empty.

OK Cancel