1. 19 Aug, 2013 1 commit
  2. 13 Aug, 2013 4 commits
  3. 12 Aug, 2013 1 commit
  4. 11 Aug, 2013 1 commit
  5. 29 Jul, 2013 1 commit
  6. 23 Jul, 2013 1 commit
    • Only revoke GRANT OPTION when user actually has it · 9d0fc0fd
      When revoking privileges from a user, the GRANT OPTION is always
      revoked, even if the user doesn't have it. If the user exists, this
      doesn't give an error, but if the user doesn't exist, it does:
      
      mysql> GRANT ALL ON test.* TO 'test'@'localhost';
      Query OK, 0 rows affected (0.00 sec)
      
      mysql> REVOKE GRANT OPTION ON test.* FROM 'test'@'localhost';
      Query OK, 0 rows affected (0.00 sec)
      
      mysql> REVOKE GRANT OPTION ON test.* FROM 'test'@'localhost';
      Query OK, 0 rows affected (0.00 sec)
      
      mysql> REVOKE ALL ON test.* FROM 'test'@'localhost';
      Query OK, 0 rows affected (0.00 sec)
      
      mysql> REVOKE GRANT OPTION ON test.* FROM 'test'@'localhost';
      ERROR 1141 (42000): There is no such grant defined for user 'test' on
      host 'localhost'
      
      Additionally, in MySQL 5.6 this breaks replication because of
      http://bugs.mysql.com/bug.php?id=68892.
      
      Rather than revoking the GRANT OPTION and catching the error, check if
      the user actually has it and only revoke it when he does.
      Stijn Tintel committed
  7. 20 Jul, 2013 2 commits
  8. 15 Jul, 2013 1 commit
  9. 14 Jul, 2013 1 commit
  10. 05 Jul, 2013 1 commit
  11. 01 Jul, 2013 1 commit
  12. 17 Jun, 2013 1 commit
  13. 15 Jun, 2013 1 commit
  14. 11 Jun, 2013 1 commit
    • Fix MySQL 5.6 compatibility · 767c208e
      In MySQL 5.6, the root account created by default during MySQL
      installation has the PROXY ... WITH GRANT OPTION privilege for ''@'',
      that is, for all users.
      
      The mysql_user module tries to revoke this privilege, but this fails:
      _mysql_exceptions.ProgrammingError: (1064, "You have an error in your
      SQL syntax; check the manual that corresponds to your MySQL server
      version for the right syntax to use near '''@'' FROM 'root'@'localhost''
      at line 1")
      
      Quick fix: don't revoke privilege if user is root and the privilege to
      revoke contains PROXY.
      Stijn Tintel committed
  15. 10 Jun, 2013 1 commit
  16. 01 Jun, 2013 3 commits
  17. 27 May, 2013 2 commits
  18. 05 May, 2013 1 commit
  19. 03 May, 2013 1 commit
  20. 28 Apr, 2013 1 commit