CONNECTION ADMIN Privilege
This page is part of MariaDB's Enterprise Documentation.
The parent of this page is: Privileges
Topics on this page:
Overview
In 10.6 ES, 10.6 CS, 10.5 ES, 10.5 CS:
Grants ability to KILL, SET (some variables only). Skips the execution of init_
connect when the user connects. Ignores max_ connections, max_ user_ connections, and max_ password_ errors when the user connects. Added in MariaDB Enterprise Server 10.5 as fine-grained SUPER privilege to reduce the dependency on SUPER. Prior to this version this will have been part of SUPER. In 10.4 ES, 10.4 CS, 10.3 ES, 10.3 CS, 10.2 ES, 10.2 CS:
Not present
See also: Privileges in 10.6 ES, in 10.6 CS, in 10.5 ES, in 10.5 CS, in 10.4 ES, in 10.4 CS, in 10.3 ES, in 10.3 CS, in 10.2 ES, and in 10.2 CS
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_ when the user connects.connections Ignores max_
password_ when the user connects.errors Allows the user to kill connections owned by other users with the KILL statement.
Allows the user to set system variables:
thread_pool_mode
CHANGE HISTORY
Release Series | History |
---|---|
10.6 Enterprise |
|
10.6 Community |
|
10.5 Enterprise |
|
10.5 Community |
|
10.4 Enterprise |
|
10.4 Community |
|
10.3 Enterprise |
|
10.3 Community |
|
10.2 Enterprise |
|
10.2 Community |
|
EXTERNAL REFERENCES
Information specific to MariaDB SkySQL can be found on the CONNECTION ADMIN page in the SkySQL Documentation.