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 root@localhost, not the root@%
> Date: Wed, 30 Sep 2009 09:37:28 -0400
> Subject: Re: Unable To Remove User
> From: carloswill@stripped
> To: mysql@stripped
> On Wed, Sep 30, 2009 at 9:12 AM, Martin Gainty <mgainty@stripped> 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=1
Show them the way! Add maps and directions to your party invites.