CONNECTION ADMIN Privilege

DETAILS

Grants ability to KILL, SET (some variables only). Added in MariaDB Enterprise Server 10.5 as fine-grained SUPER privilege to reduce the dependency on SUPER. Prior to ES10.5 CONNECTION ADMIN was part of SUPER.

• Skips the execution of init_connect when the user connects.

• Ignores max_connections when the user connects.

• Ignores max_user_connections when the user connects.

• Ignores max_password_errors when the user connects.

• Allows the user to kill connections owned by other users with the KILL statement.

• Allows the user to set system variables:

  • connect_timeout

  • disconnect_on_expired_password

  • extra_max_connections

  • init_connect

  • max_connections

  • max_connect_errors

  • max_password_errors

  • proxy_protocol_networks

  • secure_auth

  • slow_launch_time

  • thread_pool_exact_stats

  • thread_pool_dedicated_listener

  • thread_pool_idle_timeout

  • thread_pool_max_threads

  • :thread_pool_min_threads

  • thread_pool_mode

  • thread_pool_oversubscribe

  • thread_pool_prio_kickup_timer

  • thread_pool_priority

  • thread_pool_size

  • thread_pool_stall_limit

EXTERNAL REFERENCES

• Information specific to MariaDB SkySQL can be found on the CONNECTION ADMIN page in the SkySQL Documentation.