MySQL Bugs: #71790: mysqldbcompare needs more privileges than required

Bug #71790	mysqldbcompare needs more privileges than required
Submitted:	21 Feb 2014 14:00
Reporter:	Daniël van Eeden (OCA)	Email Updates:
Status:	Open	Impact on me:	None
Category:	MySQL Utilities	Severity:	S4 (Feature request)
Version:	1.3.6	OS:	Any
Assigned to:		CPU Architecture:	Any

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
mysqldbcompare tries to disable sql_log_bin for the session, which requires the SUPER privilege.

It does this to prevent the tables it creates from being replicated.

However this is not needed if binlog_format=ROW as temporary tables won't be replicated in that case (See https://dev.mysql.com/doc/refman/5.6/en/replication-features-temptables.html for details)

How to repeat:
Setup a master/slave pair with binlog_format=ROW and try to run dbcompare with a user who doesn't have the SUPER privilege.

Suggested fix:
Skip disabling the binlog if binlog_format=ROW