From 6da68049b5d28246c5773fc2caee7bef6c6fc68f Mon Sep 17 00:00:00 2001 From: Sujatha Date: Mon, 16 Nov 2020 14:31:44 +0530 Subject: MDEV-23610: Slave user can't run "SHOW SLAVE STATUS" anymore after upgrade to 10.5, mysql_upgrade should take of that Add a new privilege "SLAVE MONITOR" which will grant user the permission to execute "SHOW SLAVE STATUS" and "SHOW RELAYLOG EVENTS" commands. SHOW SLAVE STATUS requires either SLAVE MONITOR/SUPER SHOW RELAYLOG EVENTS requires SLAVE MONITOR privilege. --- mysql-test/main/grant.test | 1 + 1 file changed, 1 insertion(+) (limited to 'mysql-test/main/grant.test') diff --git a/mysql-test/main/grant.test b/mysql-test/main/grant.test index 38baf673825..a81e77567b5 100644 --- a/mysql-test/main/grant.test +++ b/mysql-test/main/grant.test @@ -1833,6 +1833,7 @@ GRANT REPLICATION SLAVE ON *.* TO mysqltest_u1@localhost; GRANT SHOW DATABASES ON *.* TO mysqltest_u1@localhost; GRANT SHUTDOWN ON *.* TO mysqltest_u1@localhost; GRANT USAGE ON *.* TO mysqltest_u1@localhost; +GRANT SLAVE MONITOR ON *.* TO mysqltest_u1@localhost; --echo SHOW GRANTS FOR mysqltest_u1@localhost; -- cgit v1.2.1