User management under a MySQL tenant

The user management feature allows you to view users under the current MySQL tenant, create and delete a user, and grant and revoke user privileges.

Prerequisites

You have the permission to modify the tenant.

Procedure

1. In the left-side navigation pane, click Tenants . The Tenant Overview page appears.

2. Find the target tenant in the Tenants list, and click the tenant name. The Overview page of the tenant appears.

3. In the left-side navigation pane, click User Management . The User Management page appears.

4. View information of the users. The Users list contains the following columns: Username , Accessible Database , Created At , Logon Connection String , Lock , and Actions .

   1. You can sort the users by the creation time.

   2. You can lock a user to disable the user from logging on to the database.

   3. For a user, you can modify the privileges, reset the password, or delete it.

   4. You can copy and view the connection string.

5. In the upper-right corner, click Create User .

   1. Specify User Name , New Password , Confirm Password , Globa l Permissions (Optional) , Databa se Permissions (Optional) .

      Parameter	Description
      New Password	The password must be 8 to 32 characters in length, and contain at least two uppercase letters, two lowercase letters, two digits, and two special characters. The supported special characters are ~!@#%^&*_-+=`|(){}[]:;',.?/
      Confirm New Password	Enter the password you specified in the New Password parameter.
      Global Permissions	Optional. For more information, see the Privileges table on this page.

   2. To grant privileges to a new user, select the databases that the user can access, click the > icon to move the databases to the right-side pane, and then select the privileges as needed.

   3. Click Submit .

6. To change the password, click Change Password in the Actions column, and set a new password in the dialog box that appears.

   

7. To modify global and database privileges, locate the row containing the user and click Modify Privilege in the Actions column.

8. To delete a user, locate the row containing the user and click Delete in the Actions column. Deleting a user may affect the business that relies on the user. Proceed with caution.

Privileges