Name |
Last commit
|
Last update |
---|---|---|
bin | ||
docs/man | ||
docsite | ||
examples | ||
hacking | ||
lib/ansible | ||
library | ||
packaging | ||
plugins | ||
test | ||
.gitignore | ||
CHANGELOG.md | ||
CONTRIBUTING.md | ||
COPYING | ||
MANIFEST.in | ||
Makefile | ||
README.md | ||
RELEASES.txt | ||
VERSION | ||
setup.py |
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.
Name |
Last commit
|
Last update |
---|---|---|
bin | Loading commit data... | |
docs/man | Loading commit data... | |
docsite | Loading commit data... | |
examples | Loading commit data... | |
hacking | Loading commit data... | |
lib/ansible | Loading commit data... | |
library | Loading commit data... | |
packaging | Loading commit data... | |
plugins | Loading commit data... | |
test | Loading commit data... | |
.gitignore | Loading commit data... | |
CHANGELOG.md | Loading commit data... | |
CONTRIBUTING.md | Loading commit data... | |
COPYING | Loading commit data... | |
MANIFEST.in | Loading commit data... | |
Makefile | Loading commit data... | |
README.md | Loading commit data... | |
RELEASES.txt | Loading commit data... | |
VERSION | Loading commit data... | |
setup.py | Loading commit data... |