ERROR 1063 (4200) when trying to drop a user

[Eric Wagar]

I am trying to drop a user via:
mysql> drop user 'wiki_user';
ERROR 1268 (HY000): Can't drop one or more of the requested users
The relevant user table:
mysql> select host,user from user;
+-----------------------+------------+
| host                  | user       |
+-----------------------+------------+
| %                     | root       |
| %                     | wiki_user  |
| localhost             | cbxoops    |
| localhost             | fg_phpnuke |
| localhost             | fg_xoops   |
| localhost             | gw_default |
| localhost             | nwcb       |
| localhost             | pm4        |
| localhost             | root       |
| localhost             | wiki_user  |
| localhost.localdomain | root       |
| localhost.localdomain | wiki_user  |
| sm.domain.com     | root       |
+-----------------------+------------+
13 rows in set (0.00 sec)
And the GRANTS:
mysql> show grants for wiki_user;
+----------------------------------------------------------------------------------------------------------+
| Grants for 
[EMAIL PROTECTED]                                                                                   
|
+----------------------------------------------------------------------------------------------------------+
| GRANT USAGE ON *.* TO 'wiki_user'@'%' IDENTIFIED BY PASSWORD 
'*7503F5BF90CD33491FD041DB75F9F3D08AE01E0B' |
| GRANT SELECT, INSERT, UPDATE, DELETE ON `wikidb`.* TO 
'wiki_user'@'%'                                    |
+----------------------------------------------------------------------------------------------------------+

What am I missing that I can't drop the user?
I would try this though phpMyAdmin, but I can't login to it, which I 
think occured after the above wiki web install.

Thanks
eric
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]