1. Home
  2. Docs
  3. ClusterControl
  4. User Guide (GUI v2)
  5. Clusters
  6. Manage

Manage

Users Management

Shows a summary of database users and privileges for the cluster. All of the changes are automatically synced to all database nodes in the cluster.

You can filter the list by Active and Inactive users. Click on Actions → Edit to update the existing user or Actions → Delete to remove the existing user. Click on Create DB User to open the user creation wizard:

Field Description
Username
  • Database username.
Password
  • Password for Username. The minimum requirement is 4 characters.
Hostname
  • Hostname or IP address range of the user or client. For the IP address range, use the IP address/subnet format, e.g, 192.168.100.0/24.
Privileges
  • Specify the privilege for this user. If the Privileges text box is active, it will list all possible privileges of the server.
  • Specify the database or table name. It can be in *.*,{database_name}, {database_name}.* or {database_name}{table_name} format.
Add Privileges
  • Add another Privileges statement builder entry for this user.
Max Queries Per Hour
  • Maximum queries this user can perform in an hour. Default is 0 (unlimited).
Max Updated Per Hour
  • Maximum update operations this user can perform in an hour. Default is 0 (unlimited).
Max Connections Per Hour
  • Maximum connections allowed for this user in an hour. Default is 0 (unlimited).
Max User Connections
  • Maximum connections allowed for this user ever. Default is 0 (unlimited).
Requires SSL
  • On – The user must be authenticated using SSL.
  • Off – This configuration setting will be skipped.
Was this article helpful to you? Yes No