Manage users in a MySQL tenant

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

Prerequisites

• You must have the permissions to modify the tenant.
• Only a primary tenant has the user management permissions.
• You cannot manage users with access restrictions on IP addresses, such as a user with the restriction of testuser@10.%.

Procedure

1. In the left-side navigation pane, click Tenants to go to the Tenants page.

2. In the tenant list, find the target tenant and click its name to go to its Overview page.

3. In the left-side navigation pane, click User Management to go to the User Management page.

4. In the user list, view the following user parameters: Username, Accessible Database, Login Connection String, Lock, and Actions.

   1. You can lock a user to prevent the user from logging on to the database.

   2. You can perform various operations on users, such as lock a user, change the password of a user, modify the privileges of a user, and delete a user.

   3. You can view and copy the logon connection string.

5. Click Create User in the upper-right corner.

   1. Configure the User Name, Password, Confirm Password, Global Privileges (Optional), and Database Privileges (Optional) parameters.

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

   2. Grant privileges to the new user. To 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. Change the password of a user: Click Change Password in the Actions column. In the dialog box that appears, change the password.

   

7. Modify the user privileges: Click Modify Permission in the Actions column to modify the global and database privileges of the corresponding user.

8. Delete a user: Click Delete in the Actions column to delete the corresponding user. Deleting a user may affect the business that involves this user. Proceed with caution.

Privileges