Revoke all privileges on *.* doesn't work

[Nico Sabbi]

Hi,
the documentation reads:

REVOKE /|priv_type|/ [(/|column_list|/)] [, /|priv_type|/ [(/|column_list|/)]] ...
    ON {/|tbl_name|/ | * | *.* | /|db_name|/.*}
    FROM /|user|/ [, /|user|/] ...
REVOKE ALL PRIVILEGES, GRANT OPTION FROM /|user|/ [, /|user|/] ...


but it doesn't work, as you can see below:


grant all privileges on *.* to user3;
Query OK, 0 rows affected (0.00 sec)

mysql> show grants for user3;
+--------------------------------------------+
| Grants for user3@%                         |
+--------------------------------------------+
| GRANT ALL PRIVILEGES ON *.* TO 'user3'@'%' |
+--------------------------------------------+
1 row in set (0.00 sec)mysql> show variables like 'version';
+---------------+----------------+
| Variable_name | Value          |
+---------------+----------------+
| version       | 4.0.21-Max-log |
+---------------+----------------+
1 row in set (0.00 sec)



mysql> revoke all privileges on *.* from user3;
Query OK, 0 rows affected (0.00 sec)

mysql> show grants for user3;
+-----------------------------------+
| Grants for user3@%                |
+-----------------------------------+
| GRANT USAGE ON *.* TO 'user3'@'%' |
+-----------------------------------+
1 row in set (0.00 sec)

mysql> flush privileges;
Query OK, 0 rows affected (0.09 sec)

mysql> show grants for user3;
+-----------------------------------+
| Grants for user3@%                |
+-----------------------------------+
| GRANT USAGE ON *.* TO 'user3'@'%' |
+-----------------------------------+
1 row in set (0.00 sec)


mysql> show variables like 'version';
+---------------+----------------+
| Variable_name | Value          |
+---------------+----------------+
| version       | 4.0.21-Max-log |
+---------------+----------------+
1 row in set (0.00 sec)



what am I doing wrong?

Thanks,

-- 
Nico Sabbi - Officine Digitali - Bologna
Tel. 051 - 4187565