List:General Discussion« Previous MessageNext Message »
From:Carlos Williams Date:September 30 2009 9:21pm
Subject:Re: Unable To Remove User
View as plain text  
On Wed, Sep 30, 2009 at 8:18 AM, Claudio Nanni <claudio.nanni@stripped> wrote:
> Remove manually (delete) the user from all the privilege tables:
>
> delete from columns_priv where user='carlos';
> delete from db where user='carlos';
> delete from procs_priv where user='carlos';
> delete from tables_priv where user='carlos';
> delete from user where user='carlos';
>
> then a nice FLUSH PRIVILEGES;
>
> this should fix, let me know!

Worked great!!!

mysql> select User, Host, Password from user;
+------+-----------+-------------------------------------------+
| User | Host      | Password                                  |
+------+-----------+-------------------------------------------+
| root | localhost | *FDCCC9BE5FC366E7D9714988DBC7F111A950C428 |
+------+-----------+-------------------------------------------+
1 row in set (0.00 sec)
Thread
Unable To Remove UserCarlos Williams30 Sep
  • Re: Unable To Remove Usermos30 Sep
    • Re: Unable To Remove UserCarlos Williams30 Sep
      • Re: Unable To Remove UserClaudio Nanni30 Sep
        • Re: Unable To Remove UserCarlos Williams30 Sep
      • Re: Unable To Remove UserGrant Allen30 Sep
        • RE: Unable To Remove UserMartin Gainty30 Sep
          • Re: Unable To Remove UserCarlos Williams30 Sep
            • RE: Unable To Remove UserLIU YAN30 Sep
RE: Unable To Remove UserJohn Daisley30 Sep