On Wed, Sep 30, 2009 at 8:18 AM, Claudio Nanni 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='carlo
ubject: 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 wrote:
> > Grant
> >
> > he is trying to login as that user
> > then drop the user he logged in as
>
> No, no a
On Wed, Sep 30, 2009 at 9:12 AM, Martin Gainty 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
2009 22:39:50 +1000
> From: gxal...@gmail.com
> To: carlosw...@gmail.com
> CC: mysql@lists.mysql.com
> Subject: Re: Unable To Remove User
>
> Carlos Williams wrote:
> > On Tue, Sep 29, 2009 at 11:36 PM, mos wrote:
> >> Why don't you just say "Drop User carl
(CMDBA)
Certified MySQL 5 Developer
Cognos BI Developer
---
Sent from HP IPAQ mobile device.
-Original Message-
From: Carlos Williams
Sent: Wednesday, September 30, 2009 12:47 PM
To: mysql@lists.mysql.com
Subject: Re: Unable To Remove User
On Tue, Sep 29, 2009 at
Carlos Williams wrote:
On Tue, Sep 29, 2009 at 11:36 PM, mos wrote:
Why don't you just say "Drop User carlos"?
Also are you logged in as root?
In my original message to the board I demonstrated the error I get on
my server when I attempt to run the 'drop user 'carlos'@'localhost';
command. Wh
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 PRIVI
On Tue, Sep 29, 2009 at 11:36 PM, mos wrote:
> Why don't you just say "Drop User carlos"?
> Also are you logged in as root?
In my original message to the board I demonstrated the error I get on
my server when I attempt to run the 'drop user 'carlos'@'localhost';
command. Why can't I remove this u
At 06:35 PM 9/29/2009, Carlos Williams wrote:
I just created a generic test user account on MySQL 5.1 and now for
some reason I am unable to remove him...
mysql> use mysql;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup w