Hello.
Revoke all privileges first. Eric Wagar <[EMAIL PROTECTED]> wrote: > 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 > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
