Let's document the changes in the privilege system made in 10.5.2.
MDEV-21743 (and a number of related tasks, liked to this task) made the following changes:
- Added new privileges:
- SET USER
- FEDERATED ADMIN
- CONNECTION ADMIN
- READ_ONLY ADMIN
- REPLICATION SLAVE ADMIN
- REPLICATION MASTER ADMIN
- Renamed the REPLICATION CLIENT privilege to BINLOG MONITOR. The old syntax is still understood for compatibility.
- Renamed the SHOW MASTER STATUS statement to SHOW BINLOG STATUS. The old syntax is still understood for compatibility.
- Modified privileges required for the following statements:
- SHOW BINLOG EVENTS
- SHOW SLAVE HOSTS
- SHOW SLAVE STATUS
- SHOW RELAYLOG EVENTS
Please see the attached HTML file for details.