hi Carloswil,
could you do below check: 1. show processlists; // is there any session logined by this user account? 2. select CURRENT_USER() ; // ensure you are logining with r...@localhost, not the r...@% best regards liuyann > Date: Wed, 30 Sep 2009 09:37:28 -0400 > Subject: Re: Unable To Remove User > From: carlosw...@gmail.com > To: mysql@lists.mysql.com > > On Wed, Sep 30, 2009 at 9:12 AM, Martin Gainty <mgai...@hotmail.com> wrote: > > Grant > > > > he is trying to login as that user > > then drop the user he logged in as > > No, no and no. I clearly showed my commands including my login to > MySQL as root. I also cleanly noted I can't even login as the user I > am trying to delete. > > I will try Claudio's suggestion and post back my results. I find it > odd that the output of users has a carriage return in it which > malformed the table output. It's not normally like that so you're > possibly right and that could be the issue! Either way I hope > Claudio's instructions resolve it. > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/mysql?unsub=liuy...@live.com > _________________________________________________________________ Show them the way! Add maps and directions to your party invites. http://www.microsoft.com/windows/windowslive/products/events.aspx