diff options
Diffstat (limited to 'mysql-test/suite/binlog/r/binlog_grant.result')
-rw-r--r-- | mysql-test/suite/binlog/r/binlog_grant.result | 14 |
1 files changed, 14 insertions, 0 deletions
diff --git a/mysql-test/suite/binlog/r/binlog_grant.result b/mysql-test/suite/binlog/r/binlog_grant.result index 618e00af72a..201e7b9e722 100644 --- a/mysql-test/suite/binlog/r/binlog_grant.result +++ b/mysql-test/suite/binlog/r/binlog_grant.result @@ -1,29 +1,43 @@ +connection default; reset master; set @saved_binlog_format = @@global.binlog_format; create user mysqltest_1@localhost; show grants for mysqltest_1@localhost; Grants for mysqltest_1@localhost GRANT USAGE ON *.* TO 'mysqltest_1'@'localhost' +connect plain,localhost,mysqltest_1,,test; +connect root,localhost,root,,test; **** Variable SQL_LOG_BIN **** +connection root; [root] set session sql_log_bin = 1; +connection plain; [plain] set session sql_log_bin = 1; ERROR 42000: Access denied; you need (at least one of) the SUPER privilege(s) for this operation **** Variable BINLOG_FORMAT **** +connection root; [root] set global binlog_format = row; set session binlog_format = row; +connection plain; [plain] set global binlog_format = row; ERROR 42000: Access denied; you need (at least one of) the SUPER privilege(s) for this operation set session binlog_format = row; ERROR 42000: Access denied; you need (at least one of) the SUPER privilege(s) for this operation **** Clean up **** +disconnect plain; +disconnect root; +connection default; set global binlog_format = @saved_binlog_format; drop user mysqltest_1@localhost; CREATE USER 'mysqltest_1'@'localhost'; GRANT REPLICATION CLIENT ON *.* TO 'mysqltest_1'@'localhost'; +connect rpl,localhost,mysqltest_1,,; +connection rpl; SHOW MASTER LOGS; SHOW BINARY LOGS; +disconnect rpl; +connection default; DROP USER 'mysqltest_1'@'localhost'; |