content_image/857481.jpg
instead granting one or more dynamic privileges, each of which confers more limited capabilities. See Dynamic Privilege Descriptions. 

<img src='content_image/857481.jpg'>

SUPER  affects the following operations and server behaviors: 

•Enables system variable changes at runtime: 

## Note 

SUPER  is deprecated, and you should expect it to be removed in a future version of MySQL. See Migrating Accounts from SUPER to Dynamic Privileges. 

•Enables server configuration changes to global system variables with SET GLOBAL  and SET PERSIST . 

The corresponding dynamic privilege is SYSTEM_VARIABLES_ADMIN . 

•Enables setting restricted session system variables that require a special privilege. 

The corresponding dynamic privilege is SESSION_VARIABLES_ADMIN . 

See also Section 5.1.9.1, “System Variable Privileges” . 

•Enables changes to global transaction characteristics (see Section 13.3.7, “SET TRANSACTION Statement” ). 

The corresponding dynamic privilege is SYSTEM_VARIABLES_ADMIN . 

•Enables the account to start and stop replication, including Group Replication. 

The corresponding dynamic privilege is REPLICATION_SLAVE_ADMIN  for regular replication, GROUP_REPLICATION_ADMIN  for Group Replication. 

•Enables use of the CHANGE REPLICATION SOURCE TO  statement (from MySQL 8.0.23), CHANGE MASTER TO  statement (before MySQL 8.0.23), and CHANGE REPLICATION FILTER  statements. 

The corresponding dynamic privilege is REPLICATION_SLAVE_ADMIN . 

•Enables binary log control by means of the PURGE BINARY LOGS  and BINLOG  statements. 

The corresponding dynamic privilege is BINLOG_ADMIN . 

•Enables setting the effective authorization ID when executing a view or stored program. A user with this privilege can specify any account in the DEFINER  attribute of a view or stored program. 

The corresponding dynamic privilege is SET_USER_ID . 

•Enables use of the CREATE SERVER , ALTER SERVER , and DROP SERVER  statements. 

•Enables use of the mysqladmin debug  command. 

•Enables InnoDB  encryption key rotation. 

The corresponding dynamic privilege is ENCRYPTION_KEY_ADMIN . 

•Enables execution of Version Tokens functions. 

The corresponding dynamic privilege is VERSION_TOKEN_ADMIN . 

