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:
Category:MySQL Utilities Severity:S4 (Feature request)
Version:1.3.6 OS:Any
Assigned to: CPU Architecture:Any

[21 Feb 2014 14:00] Daniël van Eeden
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