Skip to main content

SET PROPERTY

Description​

Sets user properties. Currently, only the number of user connections (max_user_connections) can be set using this command.

tip
  • The user properties mean the properties of users, not user_identity. For example, if two users, 'jack'@'%' and 'jack'@'192.%', are created using CREATE USER, the SET PROPERTY statement works only on user `jack``, not 'jack'@'%' or 'jack'@'192.%'.
  • Only users with the user_admin role can perform this operation.

Syntax​

SET PROPERTY [FOR 'user'] 'key' = 'value' [, 'key' = 'value']

Examples​

  1. Modify the maximum number of connections to 1000 for user jack.

    SET PROPERTY FOR 'jack' 'max_user_connections' = '1000';