Bug #64313 GRANT effected 0 rows a bug or by design?
| Submitted: | 14 Feb 2012 1:54 | Modified: | 7 Mar 2012 3:01 |
|---|---|---|---|
| Reporter: | John Bilicki | Email Updates: | |
| Status: | Closed | Impact on me: | |
| Category: | MySQL Server: Documentation | Severity: | S3 (Non-critical) |
| Version: | OS: | Windows (XP 64 Bit) | |
| Assigned to: | Paul DuBois | CPU Architecture: | Any |
[14 Feb 2012 1:54]
John Bilicki
[14 Feb 2012 5:05]
Valeriy Kravchuk
Yes, this should be mentioned at http://dev.mysql.com/doc/refman/5.5/en/grant.html and similar pages for other versions. You can check GRANT results with SHOW GRANTS, like this: macbook-pro:5.5 openxs$ bin/mysql -uroot test Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 Server version: 5.5.20-debug Source distribution Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> grant select on *.* to u2@localhost; Query OK, 0 rows affected (0.00 sec) mysql> show grants for u2@localhost; +-----------------------------------------+ | Grants for u2@localhost | +-----------------------------------------+ | GRANT SELECT ON *.* TO 'u2'@'localhost' | +-----------------------------------------+ 1 row in set (0.00 sec)
[7 Mar 2012 3:01]
Paul DuBois
Thank you for your bug report. This issue has been addressed in the documentation. The updated documentation will appear on our website shortly, and will be included in the next release of the relevant products. "When successfully executed from the mysql program, GRANT responds with "Query OK, 0 rows affected". To determine what privileges result from the operation, use SHOW GRANTS."
Portions of this website are copyright © 2001, 2002 The PHP Group
Page generated in 0.042 sec. using MySQL 8.4.7-u6-cloud
Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the
respective copyright holders.
It is not reviewed in advance
by Oracle and does not necessarily represent the opinion of
Oracle or any other party.