Bug #60082 Failed CREATE USER statement written to binary log

• Submitted: 10 Feb 2011 10:35
• Modified: 24 Mar 2011 15:21
• Reporter: Libing Song
• Status: Closed
• Category: MySQL Server: Replication
• Severity: S3 (Non-critical)
• Version: 5.5
• OS: Any
• CPU Architecture: Any

[10 Feb 2011 10:35] Libing Song

Description:
'CREATE USER foo IDENTIFIED WITH ...' statement will fail if the plugin doesn't
exist. But the query is still binlogged.

How to repeat:
source include/have_binlog_format_row.inc;
--error 1524
CREATE USER foo IDENTIFIED WITH 'my_plugin';
source include/show_binlog_events.inc;
SELECT count(*) FROM mysql.user WHERE User='foo';

Suggested fix:
It should not be binlogged.

[26 Feb 2011 0:15] Sveta Smirnova

Thank you for the report.

Verified as described.

[24 Mar 2011 15:21] Jon Stephens

Documented fix in the 5.6.3 changelog as follows:

      A failed CREATE USER statement was mistakenly written to the 
      binary log.

Closed.