MySQL Bugs: #115377: Terminology Update for MySQL Privileges

Bug #115377	Terminology Update for MySQL Privileges
Submitted:	19 Jun 2024 6:37	Modified:	19 Jun 2024 7:04
Reporter:	fander chan	Email Updates:
Status:	Verified	Impact on me:	None
Category:	MySQL Server: Security: Privileges	Severity:	S3 (Non-critical)
Version:	8.4.0	OS:	Any
Assigned to:		CPU Architecture:	Any

Description:
In MySQL 8.0.23, the SLAVE and MASTER keywords, along with related commands like SHOW SLAVE STATUS, were deprecated. These commands have been removed in the 8.4 release.

The following SQL statements have been removed (replacements in brackets):

START SLAVE (START REPLICA)
STOP SLAVE (STOP REPLICA)
SHOW SLAVE STATUS (SHOW REPLICA STATUS)
SHOW SLAVE HOSTS (SHOW REPLICAS)
RESET SLAVE (RESET REPLICA)
CHANGE MASTER TO (CHANGE REPLICATION SOURCE TO)
RESET MASTER (RESET BINARY LOGS AND GTIDS)
SHOW MASTER STATUS (SHOW BINARY LOG STATUS)
PURGE MASTER LOGS (PURGE BINARY LOGS)
SHOW MASTER LOGS (SHOW BINARY LOGS)
However, it has been found that the MySQL permission REPLICATION SLAVE still contains the SLAVE keyword.

How to repeat:
mysql> grant replication slave,replication client on *.* to {{mysql_rple_user}}@'{{ sub_nets }}';

Suggested fix:
Consider to rename it to `REPLICATION REPLICA`

Hello fander chan,

Thank you for the report and feedback.

regards,
Umesh

Related Bug #115344