diff options
| author | Sergei Golubchik <serg@mariadb.org> | 2021-04-21 12:51:39 +0200 |
|---|---|---|
| committer | Sergei Golubchik <serg@mariadb.org> | 2021-04-22 17:52:08 +0200 |
| commit | b8fad8c6bffbc7e43796fffe607b23075cfc3e2b (patch) | |
| tree | 1f959236c4c227dfc723f0bbe9fb23408ff83a27 /mysql-test/main/grant_slave_monitor.result | |
| parent | a40f29ab1933af9b7d21398136f0889d4bb3e9b0 (diff) | |
| download | mariadb-git-b8fad8c6bffbc7e43796fffe607b23075cfc3e2b.tar.gz | |
MDEV-25030 Upgrade to 10.5.9 breaks root's ability to grant
Diffstat (limited to 'mysql-test/main/grant_slave_monitor.result')
| -rw-r--r-- | mysql-test/main/grant_slave_monitor.result | 20 |
1 files changed, 20 insertions, 0 deletions
diff --git a/mysql-test/main/grant_slave_monitor.result b/mysql-test/main/grant_slave_monitor.result index ea0b7d8094c..68df790074a 100644 --- a/mysql-test/main/grant_slave_monitor.result +++ b/mysql-test/main/grant_slave_monitor.result @@ -53,3 +53,23 @@ ERROR 42000: Access denied; you need (at least one of) the SLAVE MONITOR privile disconnect con1; connection default; DROP USER user1@localhost; +# +# MDEV-25030 Upgrade to 10.5.9 breaks root's ability to grant +# +insert mysql.global_priv values ('bar', 'foo7', '{"access":274877906943,"version_id":100507,"plugin":"mysql_native_password","authentication_string":""}'), +('bar', 'foo8', '{"access":274877906943,"version_id":100508,"plugin":"mysql_native_password","authentication_string":""}'), +('bar', 'foo9', '{"access":274877906943,"version_id":100509,"plugin":"mysql_native_password","authentication_string":""}'); +flush privileges; +show grants for foo7@bar; +Grants for foo7@bar +GRANT ALL PRIVILEGES ON *.* TO `foo7`@`bar` WITH GRANT OPTION +show grants for foo8@bar; +Grants for foo8@bar +GRANT ALL PRIVILEGES ON *.* TO `foo8`@`bar` WITH GRANT OPTION +show grants for foo9@bar; +Grants for foo9@bar +GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, RELOAD, SHUTDOWN, PROCESS, FILE, REFERENCES, INDEX, ALTER, SHOW DATABASES, SUPER, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, REPLICATION SLAVE, BINLOG MONITOR, CREATE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE, CREATE USER, EVENT, TRIGGER, CREATE TABLESPACE, DELETE HISTORY, SET USER, FEDERATED ADMIN, CONNECTION ADMIN, READ_ONLY ADMIN, REPLICATION SLAVE ADMIN, REPLICATION MASTER ADMIN, BINLOG ADMIN, BINLOG REPLAY ON *.* TO `foo9`@`bar` WITH GRANT OPTION +drop user foo7@bar, foo8@bar, foo9@bar; +# +# End of 10.5 tests +# |