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';