# # # # Test that "SET binlog_format" is not allowed without BINLOG ADMIN CREATE USER user1@localhost; GRANT ALL PRIVILEGES ON *.* TO user1@localhost; REVOKE BINLOG ADMIN ON *.* FROM user1@localhost; connect user1,localhost,user1,,; connection user1; SET binlog_format=mixed; ERROR 42000: Access denied; you need (at least one of) the BINLOG ADMIN privilege(s) for this operation SET GLOBAL binlog_format=mixed; ERROR 42000: Access denied; you need (at least one of) the BINLOG ADMIN privilege(s) for this operation SET SESSION binlog_format=mixed; ERROR 42000: Access denied; you need (at least one of) the BINLOG ADMIN privilege(s) for this operation disconnect user1; connection default; DROP USER user1@localhost; # Test that "SET binlog_format" is allowed with BINLOG ADMIN CREATE USER user1@localhost; GRANT BINLOG ADMIN ON *.* TO user1@localhost; connect user1,localhost,user1,,; connection user1; SET binlog_format=mixed; SET GLOBAL binlog_format=mixed; SET SESSION binlog_format=mixed; disconnect user1; connection default; DROP USER user1@localhost;