Al Sparks wrote:
The version I'm using is:
Your MySQL connection id is 6 to server version: 4.1.22
I log on as root. I then:
mysql> show grants for 'WP_INT_BASEBALL'@'localhost';
+------------------------------------------------------------------------------------------------------------------------+
| Grants for [EMAIL PROTECTED]
|
+------------------------------------------------------------------------------------------------------------------------+
| GRANT USAGE ON *.* TO 'WP_INT_BASEBALL'@'localhost' IDENTIFIED BY PASSWORD
'*37638FAC6D9ED84696E9504AC8EA4495EA97A908' |
| GRANT ALL PRIVILEGES ON `WP_INT_BASEBALL`.* TO 'WP_INT_BASEBALL'@'localhost'
|
+------------------------------------------------------------------------------------------------------------------------+
2 rows in set (0.00 sec)
mysql> REVOKE USAGE ON *.* FROM 'WP_INT_BASEBALL'@'localhost' IDENTIFIED BY
PASSWORD '*37638FAC6D9ED84696E9504AC8EA4495EA97A908';
Query OK, 0 rows affected (0.00 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)
When I do another SHOW GRANTS:
mysql> show grants for 'WP_INT_BASEBALL'@'localhost';
+------------------------------------------------------------------------------------------------------------------------+
| Grants for [EMAIL PROTECTED]
|
+------------------------------------------------------------------------------------------------------------------------+
| GRANT USAGE ON *.* TO 'WP_INT_BASEBALL'@'localhost' IDENTIFIED BY PASSWORD
'*37638FAC6D9ED84696E9504AC8EA4495EA97A908' |
| GRANT ALL PRIVILEGES ON `WP_INT_BASEBALL`.* TO 'WP_INT_BASEBALL'@'localhost'
|
+------------------------------------------------------------------------------------------------------------------------+
2 rows in set (0.00 sec)
So what am I doing wrong? Why isn't that gone?
The 'usage' and 'all privileges' appear on separate lines because one is a
global-level privilege, and the other is database-level. 'usage' is a synonym
for 'no privileges.' See http://dev.mysql.com/doc/refman/4.1/en/grant.html.
If you're trying to remove the user, see
http://dev.mysql.com/doc/refman/4.1/en/removing-users.html
If you're frequently manipulating grant statements, converting grants into
revokes and vice versa, you might find mysql-show-grants handy
(http://sourceforge.net/mysqltoolkit).
Baron
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
