Unable to drop user in mysql

[Raghavan Chockalingam]

I am unable to drop users from root account

sql> show grants for root@localhost;
------------------------------------------------------------------------------------------------------
-------------------------------+
Grants for root@localhost
                               |
------------------------------------------------------------------------------------------------------
-------------------------------+
GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY PASSWORD '*9BC01A49104D6960C8C288548AD
884E0B580D8' WITH GRANT OPTION |
------------------------------------------------------------------------------------------------------
-------------------------------+
row in set (0.02 sec)
 
sql> select user, host from mysql.user;
--------------+--------------+
user          | host         |
--------------+--------------+
root          | %            |
selectanyhost | %            |
selectinsert  | 66.94.230.33 |
allbasics     | farvista.net |
selectonly    | farvista.net |
alltest       | localhost    |
raghavan      | localhost    |
root          | localhost    |
selectfields  | localhost    |
selectonly    | localhost    |
selecttest    | localhost    |
updatefields  | localhost    |
visitor       | localhost    |
--------------+--------------+
 rows in set (0.02 sec)
 
sql> drop user visitor;
ROR 1268 (HY000): Can't drop one or more of the requested users
sql> drop user selectonly;
ROR 1268 (HY000): Can't drop one or more of the requested users
mysql> drop user visitor@localhost;
ERROR 1268 (HY000): Can't drop one or more of the requested users
    

[ January 16, 2006: Message edited by: Raghavan Chockalingam ]