#4052 Revoking non-existent Grant Option breaks MySQL 5.6 Replication

4.0.5
open
nobody
Normal
2015-02-15
2013-08-12
No

This applies to MySQL 5.6.

phpMyAdmin removes the grant option by default if you modify user rights even if there is no grant option defined for that user, so Replication always breaks if you use phpMyAdmin to modify user rights for a certain table on which the user has no grant option.

Replication also breaks if you revoke the grant option from a database or table if the grant is not defined.

mysql> REVOKE GRANT OPTION ON testdb.test_table FROM 'testuser'@'127.0.0.1';
ERROR 1141 (42000): There is no such grant defined for user 'testuser' on host '127.0.0.1'

Leads to a "Incident: LOST_EVENTS"-Entry in binary log and makes the slaves stop.

Applies to all phpMyAdmin-Versions i suppose. Tested in 3.3.10.2 and 4.0.5.

According MySQL-Bug: http://bugs.mysql.com/bug.php?id=68892

phpMyAdmin should only execute "revoke grant option" if the user has a grant option on that table.

Discussion

  • Marc Delisle

    Marc Delisle - 2013-12-01

    Which exact MySQL 5.6 version please?

    We can work on this problem but don't you find the replication module somewhat fragile to be stopping on such an error?

     
  • Marc Delisle

    Marc Delisle - 2015-02-15
    • Priority: 5 --> Normal
     

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:

JavaScript is required for this form.





No, thanks